Measure not working as expected

[ManuelGeiger]

Hi all,

I have some values and measures like you can see in the table below.
As explenation: The GLP and also the Next GLP get multiplied by the invoiced QTY. The division between these values is the GLP impact in %.

This works fine on an item level but looking at the whole picture power bi sums up the GLP, Next GLP and QTY values and calculates based on that.

How can I achive it that the system sums up the actual calculated values and and divides those?

To be more clear: the subtotal of the column "GLP x Invoiced QTY" is 6763782,00 and the subtotal of the column "Next GLP x invoiced QTY" is 6939557,72 so I would expect a percentage difference of 2,6%.

The system on the other hand takes the sum of the GLP's and of the QTY and divides those values which lead to an overall impact of 13,2% which is not true.

[Anonymous · Accepted solution]

Hi @ManuelGeiger ,

It seems the field [GLP] and [Next GLP] is measure, could you please provide their formulas and some sample data in order to make troubleshooting? In addition, please review the solution in the following threads and check whether they can help you resolve the problem.

Fix Totals and Subtotals in DAX

Dax for Power BI: Fixing Incorrect Measure Totals

Why Your Total Is Incorrect In Power BI - The Key DAX Concept To Understand

Best Regards
Community Support Team _ Rena Ruan
If this post helps, then please consider Accept it as the solution to help the other members find it more.