Calculate percentages

[bml123]

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?

[v-zhangti · Accepted solution]

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.

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

[lbendlin]

You can use implicit measures. Add your Amount column to the visual again, then choose "Show as percentage of Grand Total"