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.
I want to create a measure, which is calculating something based on the row, which is shown on the table. So for "Gatecheck 1" I need another calculation than for "Gatecheck 2" for example. How can I differentiate?
Can I use any switch or if statement? And how?
Solved! Go to Solution.
Hey @tuncay ,
there is a switch statement that you could use.
Try it like this:
SwithcMeasure =
SWITCH(
TRUE(),
MAX( 'MyTable'[Gatecheck] ) = 1, [Measure1],
MAX( 'MyTable'[Gatecheck] ) = 2, [Measure2],
MAX( 'MyTable'[Gatecheck] ) = 3, [Measure3]
)
The idea provided by @selimovd is correct. This formula displays specific calculation results for different values of Gatecheck . Sorry, I don't know what you expected
Hey @tuncay ,
there is a switch statement that you could use.
Try it like this:
SwithcMeasure =
SWITCH(
TRUE(),
MAX( 'MyTable'[Gatecheck] ) = 1, [Measure1],
MAX( 'MyTable'[Gatecheck] ) = 2, [Measure2],
MAX( 'MyTable'[Gatecheck] ) = 3, [Measure3]
)
Can't use different measures for each column, since they have to be named differently
Hey @tuncay ,
sorry, then I didn't understand what exactly you mean.
Can you explain the desired result a little more detailed?
Best regards
Denis
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 |
---|---|
112 | |
100 | |
76 | |
74 | |
49 |
User | Count |
---|---|
145 | |
108 | |
107 | |
89 | |
61 |