Solved: Wrong totals

Mahmoodul · ‎12-21-2021

Hi guys

I have this

Goal_Max = MAX(ocb_global_misses_master_pkg[goal])

Goal_measure = SUMX(VALUES(ocb_global_misses_master_pkg[goal]),[Goal_Max])

but when I introduce this measure in a table, the total is wrong, Please help me

Thank you in advance

FarhanAhmed · ‎12-21-2021

Goal_Max = MAX(ocb_global_misses_master_pkg[goal])
Goal_measure = SUMX(VALUES(ocb_global_misses_master_pkg[SubRegion]),[Goal_Max])

Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!

Proud to be a Super User!

FarhanAhmed · ‎12-21-2021

Goal_Max = MAX(ocb_global_misses_master_pkg[goal])
Goal_measure = SUMX(VALUES(ocb_global_misses_master_pkg[SubRegion]),[Goal_Max])

Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!

Proud to be a Super User!

Mahmoodul · ‎12-21-2021

Its working fine for me now.

Wrong totals