Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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.
User | Count |
---|---|
102 | |
91 | |
84 | |
77 | |
71 |
User | Count |
---|---|
113 | |
104 | |
100 | |
73 | |
65 |