How to calculate sum of calulated measure?

[Anonymous]

Hi, I want to Calculate a measure %Sale Share.

The formula of Measure %Sale Share = Average of FY2020/Sum of Average FY2020.

Now, Average is a calculated measure.

I want to calculate the Sum of Average only for FY2020 so that I can calculate %Sale Share.

I also want to calculate A monthly moving average YTD.

Please help. This is an urgent issue.

Thanks in Advance.

[amitchandak]

@Anonymous , to have sum you need to have row context. Like I used month year. Use the correct column in place of month year

new meausre = sumx(values(Table[Month-year]),[%Sale Share])

[Anonymous]

Hi Amit,

I want to calculate %Sale Share as a measure in that:

 %Sale share = Average of FY2020/Sum of Average FY2020

Numerator=Average of FY2020

Denominator=Sum of Average FY2020

Area	Avg of FY2020 = Calculated Measure	%Sale Share
A	1	=1/10=0.1%
B	2	=2/10=0.2%
C	3	=3/10=0.3%
D	4	=4/10=0.4%
Total	10	=10/10=100%

Like this I want to calculate %Sale share.

Thanks in Advance

[v-juanli-msft · Accepted solution]

Hi @Anonymous 

Create measures

avg_2020 = CALCULATE(AVERAGE(Table2[value]),FILTER('date','date'[year]=2020))

%Sale Share = [avg_2020]/SUMX(ALL(Table2[area]),[avg_2020])

Best Regards
Maggie
Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.