Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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?
Solved! Go to Solution.
Copying DAX from this post? Click here for a hack to quickly replace it with your own table names
Has this post solved your problem? Please Accept as Solution so that others can find it quickly and to let the community know your problem has been solved.
If you found this post helpful, please give Kudos C
I work as a Microsoft trainer and consultant, specialising in Power BI and Power Query.
www.excelwithallison.com
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.
Copying DAX from this post? Click here for a hack to quickly replace it with your own table names
Has this post solved your problem? Please Accept as Solution so that others can find it quickly and to let the community know your problem has been solved.
If you found this post helpful, please give Kudos C
I work as a Microsoft trainer and consultant, specialising in Power BI and Power Query.
www.excelwithallison.com
User | Count |
---|---|
124 | |
108 | |
99 | |
62 | |
62 |
User | Count |
---|---|
137 | |
115 | |
102 | |
71 | |
61 |