Forum Discussion
Use SWITCH only in Filtred values
Hi everyone, I need to use SWITCH only for cases where there are FILTER values. For example, the function SWITCH: SWITCH( TRUE(), [Sales%] <0, "Less than 0%", [Sales%] <= 0.1, "0%-10%", [S...
I am not sure switch is the right Dax function here. What exactly do you want to achieve with your code?
but in general when you want to use a filter on some dax code you do it like this.
calculate([code], [Sales$] >= 0, [Sales#] >= 0)
I hope this helps.