Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric 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 |
---|---|
84 | |
72 | |
71 | |
68 | |
55 |
User | Count |
---|---|
94 | |
92 | |
91 | |
77 | |
70 |