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 = ...
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

     

lkalawski's avatar
lkalawski
Resident 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

 

  • ambillate's avatar
    ambillate
    Frequent Visitor
    5 years ago

    Hi, lkalawski,

     

    Thank You so much for your help.