Forum Discussion
Solved
Measure for each row
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?
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] )If you need any help please let me know.If I answered your question I would be happy if you could mark my post as a solution ✔️ and give it a thumbs up 👍Best regardsDenisBlog: WhatTheFact.biFollow me: twitter.com/DenSelimovic
4 Replies
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] )If you need any help please let me know.If I answered your question I would be happy if you could mark my post as a solution ✔️ and give it a thumbs up 👍Best regardsDenisBlog: WhatTheFact.biFollow me: twitter.com/DenSelimovicThe 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
