Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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?
Solved! Go to 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
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.
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
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
User | Count |
---|---|
128 | |
108 | |
99 | |
65 | |
62 |
User | Count |
---|---|
137 | |
115 | |
102 | |
71 | |
61 |