Forum Discussion

TomaKavi's avatar
TomaKavi
Icon for Helper I rankHelper I
4 years ago
Solved

Switch not showing correct result

Hello guys,  I have a problem and I am desperate. The below DAX is not showing proper result. If i hard code it and replace [SR1100 Total test] with lets say ,,10000,, it works, shows 10000 in the s...
DAX SWITCH
  • Anonymous's avatar
    Anonymous
    4 years ago

    Hi TomaKavi 

    I am so glad to hear that your problem has been solved , please consider Accept it as the solution to help the other members find it more quickly. 

     

    Best Regards,
    Community Support Team _ Ailsa Tao
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

johnt75's avatar
johnt75
Icon for Super User rankSuper User
4 years ago

Try changing the measure to

[SR1100 Total test]  =
CALCULATE (
[Total Value],
Total_2021[Consolidation account]
IN {
"V10000",
"V20000",
"V30000"
},
REMOVEFILTERS(Conso_Temp[Description - Normalized])
)