Forum Discussion

Marshmallow's avatar
Marshmallow
Helper II
2 years ago
Solved

Help with SWITCH Function

hi , not sure if this is the right forum but if  this is the right forum, anyone can help me please. I am stucked with my own measure.....i am trying to create a measure that will display data of the...
  • Anonymous's avatar
    Anonymous
    2 years ago

    Hi Marshmallow ,

    Below is my new table:

    The new following DAX might work for you:

    Measure = 
   var _fina = SELECTEDVALUE('Table'[Final answer])
   var result = 
      IF(_fina == "yes" , MAX('Table'[Organisation_dummy_name])," ")
    return result

    The final output is shown in the following figure:

    Best Regards,

    Xianda Tang

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi Marshmallow ,

Below is my table:

The following DAX might work for you:

Measure = 
   CALCULATE(
     MAX('Table'[Organisation_dummy_name]),
     FILTER('Table' , 'Table'[Final answer] = "yes"))

The final output is shown in the following figure:

 

Best Regards,

Xianda Tang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.