Forum Discussion

MCF's avatar
MCF
New Member
4 years ago

How to get a selector with multiple measures?

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

2 Replies

  • ValtteriN's avatar
    ValtteriN
    Icon for Community Champion rankCommunity Champion
    4 years ago

    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!

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    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