Forum Discussion

Analitika's avatar
Analitika
Icon for Post Prodigy rankPost Prodigy
5 years ago

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 ...
Need Help
Show and Tell
Tips and Tricks
V-lianl-msft's avatar
V-lianl-msft
Icon for Community Support rankCommunity Support
5 years ago

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.

Analitika's avatar
Analitika
Icon for Post Prodigy rankPost Prodigy
5 years ago

it does not matter, how sumx switch values?