Forum Discussion
Analitika
5 years agoPost Prodigy
Wrong total on switch
I use this formula _TABLE= VAR suma = SUM([suma]) VAR savi = SWITCH( SELECTEDVALUE(Table1[Names]), "xcds",1, SUM(Table3[suma]) ) VAR bp = suma-savi VAR m= DIVIDE(bp,suma) RETURN ...
V-lianl-msft
5 years agoCommunity Support
Hi Analitika ,
Unfortunately, I don't know your scenario. Could you share a sample file for me to test and know the scenario?
Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
- Analitika5 years agoPost Prodigy
it does not matter, how sumx switch values?