Forum Discussion
Slicer (Measure Count)
Hello Everyone
Could you pls help me?
I have the following table in PowerBi. The "Has Paid?" column is a measure. And I would like to create a slicer which displays
Has paid? 1 or blank to filter the ones which are blank.
Is there a way to insert this measure into a slicer?
| Name | Address | Has Paid? | total records |
| xxxxxx | yyyyy | 1 | 1 |
| aaaa | bbbb | 1 | |
| ccccc | dddd | 1 | 1 |
| ddddd | eeee | 1 | |
| ddddd | rrrrrr | 1 | 1 |
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
10 Replies
Anonymous ,
Can you please share the DAX for your measure so we can try to convert it into Column.
