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.

Marshmallow's avatar
Marshmallow
Helper II
2 years ago

Hi @Xianda, I still would like the row that doesn't have yes to be displayed but not displaying the organisation name. So taking your table as example, if Diageo PLC is not a yes for South Australia and General, it will be displayed as 

South Australia | General | [blank]

Victoria | General | Diageo PLC

 

So whilst waiting for the Final Answer to be yes, I still need to have the State and Type displayed 🙂

 

Anonymous's avatar
Anonymous
Not applicable
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.