Forum Discussion
Bug in %GT calculation
Hi all!
I've created bins to distribute the "Value". I created a matrix where each value is the sum of "Values" that fall into the exact bin.
If I select "present "Values" as a percent of grand total", I get negative values of percentages and negative value of Total in %, I expect to get abs value in % when I chose % of GT
Is it a bug?
Is there is another solution to present % of GT in absolute values?
- Is that the same data in both tables? The numbers don't seem to match.
% GT is not absolute, it should just take the value and divide by grand total value (23,218.49 in your top chart).
If you want a different calculation, please explain what the calculation should be and we can help you create custom measure. I don't really know how you would accurately create a percent when negative numbers are involved, do you need to update the total to be an absolute sum?
3 Replies
- Is that the same data in both tables? The numbers don't seem to match.
% GT is not absolute, it should just take the value and divide by grand total value (23,218.49 in your top chart).
If you want a different calculation, please explain what the calculation should be and we can help you create custom measure. I don't really know how you would accurately create a percent when negative numbers are involved, do you need to update the total to be an absolute sum? Hi Mikhail_Lourie ,
As mentioned by AllisonKennedy, it just take the value divide the grand total. If you want to get the absolute value, just create a new measure for it and use ABS function:https://docs.microsoft.com/en-us/dax/abs-function-dax
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Best Regards,
Dedmon Dai
v-deddai1-msft , AllisonKennedy, thank you for your replies!
I added ABS and it worked!
But never the less, I think it is wrong from the mathematical point of view to get NEGATIVE values of a percent.
