Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi All,
Below is the scenario. here, i have applied calculation i.e., B/A*100 which is working fine for all rows but i want to get % value in total based on the total of Column A & B.
Column A | Column B | % |
88 | 78 | 88.63636364 |
62 | 55 | 88.70967742 |
22 | 18 | 81.81818182 |
90 | 67 | 74.44444444 |
111 | 67 | 60.36036036 |
200 | 180 | 90 |
573 | 465 | 81.15183246 |
Desired Value in total is 81.151 which came by dividing sum of B by sum of A. but in power bi how to get that value (81.151) in total as well.
Thanks in advance
Solved! Go to Solution.
Can you try this in measure?
% = SUM(TableName[Column B])/SUM(TableName[Column A])
Hi @jay_patel
I guess your current % is a calculated column so it doesn't work correctly to get the total when you add it to a table or matrix visual in the report. To get the correct total, you need a measure instead. You can try the measure suggested by @Arul then format it to percentage.
To learn how Power BI calculates total and subtotal values in tables and matrices, please refer to Understanding how Power BI calculates totals
Best Regards,
Jing
If this post helps, please Accept it as Solution to help other members find it. Appreciate your Kudos!
Can you try this in measure?
% = SUM(TableName[Column B])/SUM(TableName[Column A])
User | Count |
---|---|
102 | |
91 | |
84 | |
77 | |
71 |
User | Count |
---|---|
113 | |
104 | |
100 | |
73 | |
65 |