[SOLVED] One measure show 2 information

Anything related to PowerPivot and DAX Formuale
Bernard Heymans
Posts: 28
Joined: Wed Feb 28, 2018 12:18 am

[SOLVED] One measure show 2 information

Postby Bernard Heymans » Wed Jun 26, 2019 8:42 pm

Hello all,


I 'm searching to show 2 information in one cell.

where did I get the concept: here


Image

So it should be possible...
I created a reduced example Can anybody help?


Regards,

Bernard
Attachments
2 info in one measure.xlsx
(118.79 KiB) Downloaded 29 times
Last edited by Bernard Heymans on Wed Jun 26, 2019 11:45 pm, edited 1 time in total.

Bernard Heymans
Posts: 28
Joined: Wed Feb 28, 2018 12:18 am

Re: One measure show 2 information

Postby Bernard Heymans » Wed Jun 26, 2019 11:45 pm

YESSSSs, Found!

[img]https://i.imgsafe.org/48/48331b7fa3.jpeg[/img]
Here I defined my measure :

[code]=
var NETSALES = [NS.]
var PGR = [progress]

return
if( NETSALES>0 ,
"NS: " & NETSALES &" pgr : " & FIXED(PGR *100 ,1 , 0) &"%"
)[/code]

Bernard.

Learned: [url=http://tinylizard.com/var-best-thing-happen-dax-since-calculate/]var: the best thing that appened to DAX since
CALCULATE[/url]
PS: Why don't the brackets for [ DAX ] [ / DAX] work?


Return to “PowerPivot/DAX”

Who is online

Users browsing this forum: No registered users and 2 guests