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

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

3 Replies

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

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