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 ,
You can try to put the measure into the filter pane on the right side.
Then you can filter the measure.
Aiolos Zhao
Thanks for your suggestion. Anonymous
Actually, I would like to create the slicer to give the user the option to filter the data. This is why I have asked about it
can you change the measure to a calculated column?
by the way, the user can also use the filter pane to filter the measure in the front-end.
Aiolos Zhao
Hi Anonymous
From a user point of view, it will be more user friendly to have a slicer on top of the table which allows the user to filter.
Thanks for your suggestion, anyways