Forum Discussion
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. ...
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
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:
thanks for the response, however it didnt fix it