Create measure using slicer

Question

Hi,&nbsp;I am trying to create a measure using&nbsp; slicer.If the slicer isn't selected it shows blank otherwise should show measure value.Below works when I point to calculated column but i want it to use a measure instead - which doesn't work.Measure2 = IF([Measure1] = "No", " ", VALUES(Table1[column]))&nbsp;Need help!&nbsp;&nbsp;&nbsp;

anonymous · Accepted Answer

New measure= if(isfiltered(table[col])=TRUE,[MEASURE1],BLANK())CHEEERS,.PravinIf it resolves your problem mark it as a solution and give Kudos.

Forum Discussion

Create measure using slicer

2 Replies

Related content

Need help creating a measure

Help to create DAX Measure

Can i use a measure selected in a slicer (created with field parameters) to create a rank?

Slicer on measures

Create a slicer from a measure