Bug in %GT calculation

[Mikhail_Lourie]

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?

[v-deddai1-msft]

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

[Mikhail_Lourie]

@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.  

[AllisonKennedy · Accepted solution]

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?