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 table, the total is wrong, Please help me
 
Thank you in advance
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])

2 Replies

  • 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])