Forum Discussion

ambillate's avatar
ambillate
Frequent Visitor
5 years ago
Solved

How to create a measure based on Row Value

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.

 

Need Help
  • lkalawski's avatar
    lkalawski
    5 years ago

    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

     

3 Replies

  • lkalawski's avatar
    lkalawski
    Icon for Resident Rockstar rankResident Rockstar
    5 years ago

    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