topic Re: Help with SWITCH Function in DAX Commands and Tips

Help with SWITCH Function

Marshmallow — Wed, 22 Nov 2023 23:57:06 GMT

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

Re: Help with SWITCH Function

Anonymous — Thu, 23 Nov 2023 02:47:43 GMT

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.

Re: Help with SWITCH Function

Marshmallow — Thu, 23 Nov 2023 02:57:13 GMT

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 🙂

Re: Help with SWITCH Function

Anonymous — Thu, 23 Nov 2023 03:05:20 GMT

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.