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 ...