Forum Discussion

Greg_Deckler's avatar
Greg_Deckler
Icon for Community Champion rankCommunity Champion
10 years ago

Dealing with Measure Totals

This one has come up quite a bit recently. The issue surrounds using Measures in Table visualizations with a Total row. The complaint is that the "Total" row is "wrong" for the measure. Technically, ...
Anonymous's avatar
Anonymous
Not applicable
5 years ago

Hi Everyone, 

 

Im not sure if this is the right subject to be asking this but I really need some help. I'm trying to calculate the sum of the column "Cases Needed". The result shoul be 9 instead of 53. I Understand why this difference occurs but I don't know how to fix it in my case. This table almost all the information are measures that do not refer to columns. If there is any way that someone can help me, I appreciate it. 

 

Cases Needed = ROUNDUP(DIVIDE(IF([ETD]>[Weeks],VALUE(0),([Weeks]-[ETD])*[Average]),[Case]),0)

 

NewCasesNeeded =
IF(
HASONEFILTER(OBJ_TAB[UPC]),
ROUNDUP(DIVIDE(IF([ETD]>[Weeks],VALUE(0),([Weeks]-[ETD])*[Average]),[Case]),0),???? (No idea how to finish the measure)
 
 
  • Ashish_Mathur's avatar
    Ashish_Mathur
    Icon for Super User rankSuper User
    5 years ago

    Hi,

    Does this measure work?

    Measure1 = SUMX(VALUES(OBJ_TAB[UPC]),[Cases Needed])

    • Anonymous's avatar
      Anonymous
      Not applicable
      5 years ago

      Thanks!!! Is working 🙂 Ashish_Mathur 

      • Ashish_Mathur's avatar
        Ashish_Mathur
        Icon for Super User rankSuper User
        5 years ago

        You are welcome.  If my reply helped, please mark it as Answer.