Forum Discussion
Post PatronCalculate percentages
Hi,
I have data like this and need to calculate percentages
| 2021 | Amount | Percentage | |
| Oct | 10 | 12% | |
| Nov | 4 | 5% | |
| Dec | 5 | 6% | |
| 2022 | Jan | 6 | 7% |
| Feb | 10 | 12% | |
| Mar | 5 | 6% | |
| Apr | 15 | 18% | |
| May | 20 | 24% | |
| Jun | 10 | 12% | |
| Total | 85 | 100% |
How do I achieve this?
Hi, bml123
Please check the following methods.
Percentage = DIVIDE ( SUM ( 'Table'[Amount] ), CALCULATE ( SUM ( 'Table'[Amount] ), ALL ( 'Table' ) ) )Is this the result you expect?
Best Regards,
Community Support Team _Charlotte
If this post helps, then please consider Accept it as the solution to help the other members find it more.
3 Replies
- lbendlin
Super User
You can use implicit measures. Add your Amount column to the visual again, then choose "Show as percentage of Grand Total"
- Ashish_Mathur
Hi,
You should create a Calendar Table with calculated column formulas for Year, Month name and Month number. Sort the Month name by the Month number. Create a relationship (Many to One and Single) from the Date column in your Data to the Date column in the Calendar Table. To your visual, drag Year and Month name from the Calendar Table. Write these measures:
Amount = sum(Data[Value])
% amount = calculate([Amount],all(Calendar))
Hope this helps.
v-zhangtiCommunity Support
Hi, bml123
Please check the following methods.
Percentage = DIVIDE ( SUM ( 'Table'[Amount] ), CALCULATE ( SUM ( 'Table'[Amount] ), ALL ( 'Table' ) ) )Is this the result you expect?
Best Regards,
Community Support Team _Charlotte
If this post helps, then please consider Accept it as the solution to help the other members find it more.
