Measure/calculation based on overall average

[topazz11]

I want to calculate and create a column using the measure.

Based on the filter, it needs to be calculated as below. (overall average value x amount in each row)

I cannot find a solution.  Do you have any idea how to solve this? Please suggest.

Type	Value	Amt	Desired Calculation/Output
CCC	0.23	0.78	=8.38*0.78    =	6.53
AAA	14.30	32.46	=8.38*32.46  =	271.82
DDF	0.62	1.13	=8.38*1.13    =	9.44
CHT	11.10	43.30	=8.38*43.30  =	362.63
GJU	4.38	21.06	=8.38*21.06  =	176.38
CHA	19.62	115.50	=8.38*115.5  =	967.33
avg	8.38

[VahidDM · Accepted solution]

Hi @topazz11 

Try this:

Measure =

Var _A = CALCULATE(AVERAGE('Table'[Value]),REMOVEFILTERS('Table'[Type]))

return

max('Table'[Amt])*_A

the output:

If this post helps, please consider accepting it as the solution to help the other members find it more quickly.
Appreciate your Kudos!!
LinkedIn: www.linkedin.com/in/vahid-dm/