cancel
Showing results for
Did you mean:

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Frequent Visitor

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

1 ACCEPTED SOLUTION
Community Support

Hi @Marshmallow ,

Below is my new table:

The new following DAX might work for you:

Measure =
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 3
Frequent Visitor

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 🙂

Community Support

Hi @Marshmallow ,

Below is my new table:

The new following DAX might work for you:

Measure =
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.

Community Support

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.

Announcements

#### Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

#### Power BI Monthly Update - June 2024

Check out the June 2024 Power BI update to learn about new features.

#### Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.

Top Solution Authors
Top Kudoed Authors