Forum Discussion

Silverfam's avatar
Silverfam
Frequent Visitor
6 years ago

Switch returning multiple values

Situation: I want the user to choose a product from a slicer and depending on that product I want multiple values to be visible in a graph.
If another prodcuct gets chosen, I want other measures to be visible. 

I build 2 switch measures and these work OK, but it's not really what I need. 
for example. If Product A gets chosen - measures 1, 2 and 3 should be visible in the graph.
I added an extra slicer so the user could in an extra step filter out Measure 1, 2, 3 if  thats needed.
But by default all measures should be visible in the graph.

The problem is, I managed to add 1 measure to the graph but not all 3. 
How can I solve this problem? 


Main Switch measure: 

Switch Test Product =
SWITCH(TRUE(),
    HASONEVALUE(Products[Product]),
        SWITCH(SELECTEDVALUE(Products[Product]),
        "Hub", [Switch test CF],
        "Marketplace", [Switch test MP]
)
)
 
One of the Sub Switch measures
Switch test Marketplace =
        SWITCH(
    SELECTEDVALUE('Evolution Metrics'[Evolution Metric]),
        "New ARR", [New ARR MP CC],
        "Deal driven Upsell" , [Deal Driven Upsell MP CC],
        "Organic Upsell", [Organic Upsell MP CC],
        "Downsell", [Downsell MP CC],
        "Churn", [Churn MP CC])
        
Need Help

4 Replies

  • v-eachen-msft's avatar
    v-eachen-msft
    Community Support
    6 years ago

    Hi Silverfam ,

     

    Could you please share your sample data and excepted result to me if you don't have any Confidential Information. Please upload your files to OneDrive and share the link here.

     

    • Silverfam's avatar
      Silverfam
      Frequent Visitor
      6 years ago

      Not possible to share sample data, it's confidential. 
      But I can elaborate more if that would help you. 


      What extra info would you need? 

      Thx in advance

    • Silverfam's avatar
      Silverfam
      Frequent Visitor
      6 years ago

      HI v-eachen-msft ,

      I just need to figure out how to visualize multiple measures based on one single select from a slicer. 
      If the user selects Slicer option A, I want to visualize measure 1 and 2 and 3. If the user selects slicer option B, I want to visualize measure 4 and 5 and 6. 
      I though switch was the right way to go, but maybe there is anonther, better way to do this?