How to get a selector with multiple measures?

[MCF]

I want to try this but it doesnt work, I would like if I select "Pax" I want to show in a bar chart two measures "Consulta $" and "Consulta Pax".

If I separate the condition into two parts, it only reads me the first, some idea or solution to what I want to achieve

Thank you

[Anonymous]

Hi @MCF ,

Could you please provide the formula of measures [Consulta $] and [Consulta Pax]? What's the data type of their return values? What's your final expected result? Please provide the backend logic and special example to describe it. Thank you.

Bset Regards

[ValtteriN]

Hi,

I am pretty sure what you are trying to achieve isn't possible with a single measure. However, I think we can use two measures to achieve what you are trying to do.

Two switch measures:
You can create two measures one of which is your main switch measure and contains all of your options and the second is only used for "Pax" selection and otherwise returns blank.

First measure = var selected = MAX('Measure Slicer'[Measure]) return

SWITCH(selected,"Pax",[Measure 2],"Measure 1",[Measure 1])

Second measure = var selected = MAX('Measure Slicer'[Measure]) return

SWITCH(selected,"Pax",[Measure 1],BLANK())

End result with this:

I hope this can be used to solve your issue and if it does consider accepting this as a solution!