Weighted Average between 2 calculate measures

[PshemekFLK]

Hello, 

I have 2 measures:

Measure1 = CALCULATE([Measure2],ALL(Table1),Table4[Column1]>5)

Measure3 = CALCULATE(MAXX(Table2,RELATED(Table3[Column2])),ALL(Table4))

I try to create a weighted average:

DIVIDE(SUMX(Table4,Measure1*Measure3),Measure1))

but it just results in SUM of Measure 3

What am I doing wrong?

[VahidDM]

Hi @PshemekFLK 

There is an issue with the structure of your Measure3; you added two expressions, and why did you add ALL(Table4)?

How to Get Your Question Answered Quickly

If this post helps, please consider accepting it as the solution to help the other members find it more quickly.

Appreciate your Kudos

[PshemekFLK]

Hi @VahidDM 

Sorry, I put the measure incorrectly initially. Now it's correct in the initial post. Measure 3 is also a CALCULATE

I need ALL in Measure 3 because it should ignore the filters on Table4.

I'm starting to think that I'm missing KEEPFILTERS somewhere since introducing SUMX in the weighted average measure totally ignores the filters added in Measure 1 and Measure 3. Am I on the right track?