back Has a solution

Total Sum of a measure

Im trying to SUM the WMAPE values.

How do i solve this one ? Thanks!

Best answer/comment

Try,

test total =
SUMX(
SUMMARIZE( 'Write OFFs db 19',stores[Store name], "t",
CALCULATE(
SUM('Write OFFs db 19'[Write OFFs Cost Loss]),
FILTER('Write OFFs db 19','Write OFFs db 19'[Period]>=max('Stocktakes dates FY19'[FY19_first_count]))
)
),
[t]*1
)

What you need to do is create virtual table using "summarize", then on this virtual table perform "sumx" *1.
2019-12-02 10:12:46

Comments

Be polite! In every comment!

Try, test total = SUMX( SUMMARIZE( 'Write OFFs db 19',stores[Store name], "t", CALCULATE( SUM('Write OFFs db 19'[Write OFFs Cost Loss]), FILTER('Write OFFs db 19','Write OFFs db 19'[Period]>=max('Stocktakes dates FY19'[FY19_first_count])) ) ), [t]*1 ) What you need to do is create virtual table using "summarize", then on this virtual table perform "sumx" *1.
2019-12-02 10:12:46

Comment

You must write a longer mail or/and comment!