Forum Discussion

NewtoROB's avatar
NewtoROB
New Member
6 months ago
Solved

Switch issues

I am new Power BI so the answer may be obvious. I have two indivdual mesures which work (one shows the average of the data, the other shows the median). however am having issues when using a switch.

 

When I click on Average the data show ...

But when I click on the Median I get ...

Using the mesure only without the switch does show the data 

The Switch code is

"SWITCH(VALUES('Calculation Method'[Calc Method]),"Average",[Average Wait List],"Median",[Median Wait List])"

 

How do I fix it ?

Need Help
  • NewtoROB's avatar
    NewtoROB
    6 months ago

    Thanks for all the response, the solution was a ghost space. the 'Calculation Method' table actually had a leading  space (e.g.,  " Median"). Now it's working 

6 Replies

  • NewtoROB's avatar
    NewtoROB
    New Member
    6 months ago

    Thanks for all the response, the solution was a ghost space. the 'Calculation Method' table actually had a leading  space (e.g.,  " Median"). Now it's working 

  • pankajnamekar25's avatar
    pankajnamekar25
    Super User
    6 months ago

    Hello NewtoROB 

     

    Try this DAX

    Selected Wait List :=

    SWITCH(

        SELECTEDVALUE('Calculation Method'[Calc Method]),

        "Average", [Average Wait List],

        "Median", [Median Wait List]

    )

     


    If my response helped you, please consider clicking
    Accept as Solution ✅ and giving it a Like 👍 – it helps others in the community too.


    Thanks,


    Connect with me on:

    LinkedIn

     

    • NewtoROB's avatar
      NewtoROB
      New Member
      6 months ago

       thanks for the response, however it didnt fix it 

  • hnguy71's avatar
    hnguy71
    Super User
    6 months ago

    Hi NewtoROB 

    Could be a few issues.

     

    On the top of my head, issues could be relating to:

    1. the measure itself not returning the correct value
    2. the slicer is filtering out the required information
    3. you may need to disconnect the slicer from the model

     

    Would you be able to provide a sample model?

  • cengizhanarslan's avatar
    cengizhanarslan
    Super User
    6 months ago

    Please try the measure below:

    Avg/Med Wait List =
VAR _method = SELECTEDVALUE ( 'Calculation Method'[Calc Method], "Average" )
RETURN
SWITCH (
    _method,
    "Average", [Average Wait List],
    "Median",  [Median Wait List],
    [Average Wait List] 
)