Measure as a Slicer

[Anonymous]

Hi Guys,

Do you have maybe an idea how a measure could be used as a Slicer?

In my device inventory data, there are some cases where multiple users are logged into the same devices. I created a measure called "Max User" which holds the username of who is logged into the device more frequently.

DeciveID	Max User
1	A
2	B
3	C
4	D
5	E

Now I would like to create a Slicer, based on this measure so that I can filter some visuals based on the username. However, I am unable to put the measure as a slicer.

I would appreciate your help on this.

TIA!

[v-yiruan-msft · Accepted solution]

Hi  @Anonymous ,

The measure CAN NOT be applied the slicer. You can create a measure to get a flag which can judge if the user can be displayed or not, and apply a visual-level filter on the visual with the condition(like Flag is 1)... You can refer the following links to get it:

Show most 5 recent records based on date and team name

Measure as Slicer - Workaround?

How to use a measure with a slicer in power bi

If the above one can't help you get the desired result, please provide some sample data in your tables (exclude sensitive data) with Text  format and your expected result with backend logic and special examples. It would be helpful to find out the solution. You can refer the following links to share the required info:

How to provide sample data in the Power BI Forum

How to Get Your Question Answered Quickly

And it is better if you can share a simplified pbix file. You can refer the following link to upload the file to the community.

How to upload PBI in Community

Best Regards