Wrong totals

[Easley06]

Hi, 

is there a way to get the right totals for this measure i need to add those 3 vertical to use in Card Visual the output should be 22.35

Formulas:

measure1 = [4 week AVG] * [measure2]

4 week AVG:= DIVIDE([ACTIVE REQUISITIONS],[AVG of Last 4 Weeks of 12 Weeks],0)

measure2 = DIVIDE([ACTIVE REQUISITIONS],[Measure],0)

Measure = CALCULATE([ACTIVE REQUISITIONS],ALL(FACT_Rcrtmnt_Move_Tracker_Req[Vertical]))

Total of this should be 22.35 

Thanks.

[DimaMD · Accepted solution]

Hi @Easley06 try it 

newmeasure= SUMX( VALUE(Vertical), [measure1])