Forum Discussion
The total generated by the table display does not work
Good afternoon community, I'll tell you the problem I have.
I'm creating a table visualization, I have a column called "ADJUSTMENT OF m2" which is the result of the subtraction of two columns let's call them "COLUMN A" - "COLUMN B", with the condition that "COLUMN A" is greater than "COLUMN B" to avoid negative results, if so I place a 0.
The detail is that the total generated by the visualization is wrong, it seems that it adds all the values, even those that have negative results, it does not take into account the value 0
It's the example with negative values
It is the example by conditioning the negative values and placing them at 0, the result should be 710.88, but somehow it takes into account the negative values and not the zeros
I would greatly appreciate your support, as I can't find a way to make it work well.
Thank you so much for the support, this video helped me a lot https://youtu.be/n4TYhF2ARe8
3 Replies
Syndicate_Admin First, please vote for this idea: https://ideas.powerbi.com/ideas/idea/?ideaid=082203f1-594f-4ba7-ac87-bb91096c742e
This 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/63376
Also, 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/547907
Also: https://youtu.be/uXRriTN0cfY
And: https://youtu.be/n4TYhF2ARe8Thank you so much for the support, this video helped me a lot https://youtu.be/n4TYhF2ARe8
Read my article here. https://exceleratorbi.com.au/use-sum-vs-sumx/
towards the bottom is a section "totals don't add up".
