Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hello,
I have a measure with calculates a budget. I want to replace the expression with another, but only when a certain category is used. Please see below the example. Thanks in advance.
Budget Calculation(Matrix Visual)
Category First Measure Category 2nd Measue Desired Result
A 500 A 7000 A 500
B 600 B 7000 B 7000
C 100 C 7000 C 100
In this instance only category b will be replaced. Any help would be greatly appreciated.
Solved! Go to Solution.
Hello @rtaylor
I am assuming your Category is in a seperate column.
Desired Result = IF ( SELECTEDVALUE ( Table[Category] ) = "B", [Category First Measure], [Category 2nd Measure] )
Hello @rtaylor
I am assuming your Category is in a seperate column.
Desired Result = IF ( SELECTEDVALUE ( Table[Category] ) = "B", [Category First Measure], [Category 2nd Measure] )
Thanks so much. I knew it was something simple.
User | Count |
---|---|
106 | |
89 | |
81 | |
76 | |
73 |
User | Count |
---|---|
112 | |
104 | |
96 | |
74 | |
66 |