Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi Everyone,
I am trying to write a measure which changes the column used for calculation based on filter selection.
Example: If the selected filter value is A, measure should calculate using column 1, if selected filter value is B, then the measure should calculate using column 2, if nothing is selected, it should calulate using column 3.
How do I write this measure?
Or I am looking it in a wrong way and need to modify the data model?
Solved! Go to Solution.
You may use SELECTEDVALUE Function inside SWITCH Function to add a measure.
You may use SELECTEDVALUE Function inside SWITCH Function to add a measure.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
117 | |
104 | |
77 | |
73 | |
50 |
User | Count |
---|---|
145 | |
109 | |
108 | |
90 | |
64 |