How can I use a measures output as a slicer ?

[Anonymous]

Hi, is it possible to use a measure's output as a filter? In my model, depending on how many sales an employee has of a certain product in a specified time period determines the type of sales rep that the employee is, so this is why I have to use a measure to calculate what type of sales rep the employee is. Below the measure that I am currently using to calculate what type of sales rep they are: 

Sales Rep Type = 
Switch(
     True(),
     [Sports_Rep] > .4, "Sports Rep",
     [Family_Rep] >.4, "Family Rep", 
     [First_Time_Rep] >.4, "1st Time Buyer Rep",
     "General") 

 Where [Sports_Rep] is a measure that calculates the percentage of total sales that were dedicated to sports - if that measure is greater than .4, then that employee is a "Sports Rep" 

Does anyone have any ideas on how to make the "Sports Rep", "Family Rep", "1st Time Buyer Rep" and "General" into a slicer that I can use to change the data on the report? 

[Ashish_Mathur]

Hi,

I'd like to help.  Share some data that can be copied into an MS Excel file or share the link from where i can download your PBI file.

[Anonymous]

Hi Ashish, 

I have attached a github link for a power bi file that describes the problem I am having. 

https://github.com/Zar117/Power-BI-Rank-Based-On-Switch-Measure 

Thank you for willing to help out 

@Ashish_Mathur @v-deddai1-msft 

[v-deddai1-msft · Accepted solution]

Hi @Anonymous ,

Measure can't be used as page-level filter. I suggest create another table:

Use it as slicer, and put filter: xxxxx = SELECTEDVALUE('Table'[Column]) in all visuals in your report.

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Best Regards,

Dedmon Dai