Forum Discussion
Why doesn´t sum correctly the total
Dear all,
Regarding this post that was answered perfectly by Fowmy (Thank you much again).
https://community.fabric.microsoft.com/t5/Desktop/Switch-and-add-a-result/m-p/3603521
Do you know whyt doesn´t not sum the total correctly?
Hi godtooro ,
This is related with context, when you are at month level you have the report, period type and type defined specifically for each one, when you get to the total all of the values on each of this values are there.
For example when refering to Period Type ="T" for example, in the total values this level of detail is not true because since you have an aggregation of several values you get values "T" and others that way the calculation being and IF statement, does not returt the correct result for this you need to use a SUMX syntax based on the context of the table.
Check this blog post with a more technical explanation.
https://www.sqlbi.com/articles/why-power-bi-totals-might-seem-inaccurate/
1 Reply
Hi godtooro ,
This is related with context, when you are at month level you have the report, period type and type defined specifically for each one, when you get to the total all of the values on each of this values are there.
For example when refering to Period Type ="T" for example, in the total values this level of detail is not true because since you have an aggregation of several values you get values "T" and others that way the calculation being and IF statement, does not returt the correct result for this you need to use a SUMX syntax based on the context of the table.
Check this blog post with a more technical explanation.
https://www.sqlbi.com/articles/why-power-bi-totals-might-seem-inaccurate/