[SOLVED] One measure show 2 information

Anything related to PowerPivot and DAX Formuale
Bernard Heymans
Posts: 18
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 13 times
Last edited by Bernard Heymans on Wed Jun 26, 2019 11:45 pm, edited 1 time in total.

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

Re: One measure show 2 information

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

YESSSS, Found!

Image
Here I defined my measure :

{L_CODE}{L_COLON} {L_SELECT_ALL_CODE}

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

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


Bernard.

Learned: var: the best thing that appened to DAX since
CALCULATE

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 3 guests