Forum Discussion

Mahmoodul's avatar
Mahmoodul
Icon for Helper I rankHelper I
4 years ago
Solved

Wrong totals

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 ...
Need Help
  • FarhanAhmed's avatar
    FarhanAhmed
    4 years ago
    Goal_Max = MAX(ocb_global_misses_master_pkg[goal])
Goal_measure = SUMX(VALUES(ocb_global_misses_master_pkg[SubRegion]),[Goal_Max])
FarhanAhmed's avatar
FarhanAhmed
Icon for Community Champion rankCommunity Champion
4 years ago
Goal_Max = MAX(ocb_global_misses_master_pkg[goal])
Goal_measure = SUMX(VALUES(ocb_global_misses_master_pkg[SubRegion]),[Goal_Max])
  • Mahmoodul's avatar
    Mahmoodul
    Icon for Helper I rankHelper I
    4 years ago

    Thank you FarhanAhmed 

    Its working fine for me now.