Slicer (Measure Count)

[Anonymous]

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

[Tahreem24]

@Anonymous ,

Can you please share the DAX for your measure so we can try to convert it into Column.

[Anonymous]

Hi @Tahreem24 

Thanks for your reply

I will share it as long as getting back to the office.

[v-easonf-msft · Accepted solution]

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:

Sample pbix attached

 You can refer to following posts for more detail:

https://community.powerbi.com/t5/Desktop/Use-Measure-as-Slicer/m-p/1027997

https://community.powerbi.com/t5/Desktop/Cannot-use-measure-in-slicer/m-p/166909

 

Best Regards,
Community Support Team _ Eason

 

[Anonymous]

Thank you @v-easonf-msft . Worked perfeclty. 🙂

[Anonymous]

Hello @Tahreem24 

See the DAX below

Has Paid? =

IF (

[TotalActivePayersCount] = BLANK (),

BLANK(),

DISTINCTCOUNT ( Payments[ID] )

)

[Tahreem24]

@Anonymous 

Try copying the same in Column and use in the slicer.

[AiolosZhao]

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

[Anonymous]

Thanks for your suggestion. @AiolosZhao 

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

[Anonymous]

Hi @AiolosZhao 

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 

[AiolosZhao]

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