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
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:
Community Support Team _ Eason
Thank you v-easonf-msft . Worked perfeclty. 🙂