INCORRECT SUM

Question

Hello good morning, I have the following table, all are measures, AC Fernando throws me values calculated by a switch, however the sum is wrong, as I can solve help please, I do not know how to solve it, this is the code of the measure:

CF FERNANDO =

SWITCH(

TRUE(),

[% FERNANDO]<70, 0,

[% FERNANDO]<80, [VentasTotales]*0.07,

[% FERNANDO]<90, [VentasTotales]*0.08,

[% FERNANDO]<100, [VentasTotales]*0.09,

[% FERNANDO]<110, [VentasTotales]*0.1,

[% FERNANDO]<120, [VentasTotales]*0.110,

[% FERNANDO]<1000, [VentasTotales]*0.120

)

and the measure AC FERNANDO

AC FERNANDO =

CALCULATE(

[CF FERNANDO], FILTER(C_PRODUCTO, [CF FERNANDO]>0)

Switch Measure Summary with measures switch DAX SUM OF MAXIMUM VALUES, DOES NOT ALLOW 😞 ME Cumulative sum goes wrong

greg_deckler · Answer

Syndicate_Admin&nbsp;First, please vote for this idea: https://ideas.powerbi.com/ideas/idea/?ideaid=082203f1-594f-4ba7-ac87-bb91096c742eThis looks like a measure totals problem. Very common. See my post about it here: https://community.powerbi.com/t5/DAX-Commands-and-Tips/Dealing-with-Measure-Totals/td-p/63376Also, this Quick Measure, Measure Totals, The Final Word should get you what you need:https://community.powerbi.com/t5/Quick-Measures-Gallery/Measure-Totals-The-Final-Word/m-p/547907Also: https://youtu.be/uXRriTN0cfYAnd: https://youtu.be/n4TYhF2ARe8

Forum Discussion

INCORRECT SUM

1 Reply

Related content

Incorrect SUM

Showing incorrect avg sum ?

SUM INCORRECT

incorrect sum

column sum incorrect