Totals are wrong in Aggregation

Ciao Pfoster,

at the lower level, calculations are going by customer or article and at that level of detail your DAX works correctly, you say

Therefore, we must force the code to work always customer by customer or article by article (or by tuples article - customer)

Now, you say that one of your measures works perfectly at all levels, can you show that measure code?

So I can inspect it

Anyway, just to give you an idea, the SUMMARIZE will have to change probably and the RETURN statement

Of course if you could please show data samples, pictures of the error, model layout and arrangements of the visual wjere you see the bad total, that would help helping you

If this helped, please consider giving kudos and mark as a solution

@me in replies or I'll lose your thread

Want to check your DAX skills? Answer my biweekly DAX challenges on the kubisco Linkedin page

Consider voting this Power BI idea

Francesco Bergamaschi

MBA, M.Eng, M.Econ, Professor of BI