How to create a measure based on Row Value

[ambillate]

Hi, Good Day.

I am a newbie in Power BI.

Is it possible to combine the three formulas in one measure?

For Example, to find the Percentage for every type

Type A = (X+Y)/2

Type B = (W+X)/2

Type C = (U+V)/2

Thank You.

[ambillate]

Thank You 🙂

[lkalawski · Accepted solution]

Hi @ambillate 

Yes, you can use SELECTEDVALUE function or MAX function. 

For Example: 

SWITCH(SELECTEDVALUE(Table[Type]),
"A", Formula 1,
"B", Formula 2,
Other)

Proud to be a Super User. If I helped, please accept the solution and give kudos!  Linkedin

[ambillate]

Hi, @lkalawski,

Thank You so much for your help.