Help with SWITCH Function

[Marshmallow]

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 first two column once i type 'yes' in the third column.  

at the moment i am using switch(true(),max(table[final answer])="Yes", Max(Table[Organisation_dummy_name]),"")

however when i entered yes, it displays wrong answer...

I am expected to see South Australia, General, Diageo PLC in the table below when i entered "Yes" in the Final Answer of the table above (data source)

Can someone please help :)...I didn't know what's missing 

[Marshmallow]

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 · Accepted solution]

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]

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.