Forum Discussion
Slicer (Measure Count)
Hi , Anonymous
Measure cannot be used in slicer.It is recommended that you convert the measure into a calculated column and use it as a filter if possible.
In addition ，here is another workaround .
1.Create a seperate table ( use the new field "Has paid" as a slicer)2.Create a measure as below and apply it to the visual filter pane:
visual control = IF([Measure Has paid] in DISTINCT('Seperate table'[Value]),1,BLANK())The result will show as below:
You can refer to following posts for more detail:https://community.powerbi.com/t5/Desktop/Use-Measure-as-Slicer/m-p/1027997https://community.powerbi.com/t5/Desktop/Cannot-use-measure-in-slicer/m-p/166909Best Regards,
Community Support Team _ Eason
Anonymous ,
Can you please share the DAX for your measure so we can try to convert it into Column.
Hello Tahreem24
See the DAX below
Has Paid? =IF ([TotalActivePayersCount] = BLANK (),BLANK(),DISTINCTCOUNT ( Payments[ID] ))Anonymous
Try copying the same in Column and use in the slicer.
Hi , Anonymous
Measure cannot be used in slicer.It is recommended that you convert the measure into a calculated column and use it as a filter if possible.
In addition ，here is another workaround .
1.Create a seperate table ( use the new field "Has paid" as a slicer)2.Create a measure as below and apply it to the visual filter pane:
visual control = IF([Measure Has paid] in DISTINCT('Seperate table'[Value]),1,BLANK())The result will show as below:
You can refer to following posts for more detail:https://community.powerbi.com/t5/Desktop/Use-Measure-as-Slicer/m-p/1027997https://community.powerbi.com/t5/Desktop/Cannot-use-measure-in-slicer/m-p/166909Best Regards,
Community Support Team _ EasonThank you v-easonf-msft . Worked perfeclty. 🙂