Forum Discussion

AlexDawson111's avatar
AlexDawson111
Frequent Visitor
3 years ago

Totals Summing All Table

Hi,

 

I have the following data. I would like the max remaining labor units to sum correctly. When i use the sum of the remaining labor units its summing the whole of the table.

 

Green Values are Correct, Pink Values are not what i want. The correct value should be 1425.6

 

 

Thanks

Need Help

5 Replies

  • Yossarian's avatar
    Yossarian
    Helper I
    3 years ago

    Hi AlexDawson111 ,

     

    Just try SUMX ( Table, [Max of Remaining Labor Units] ).
    If it is still to large a number, you should then summarize the table ( SUMMARIZE(Table, Table[Project ID], Table[Task Code], Table[Sub Discipline Group], Table[Week End Date] ).

     

    Hope it helps.

    • AlexDawson111's avatar
      AlexDawson111
      Frequent Visitor
      3 years ago

      Thanks,

       

      So the SUMX(SUMMARIZE also was too high.

       

      Ill explain what im trying to acheive. I have a fact table that holds remaining units. Each row in the table is a week end date.

       

      For example columns are :- TASK ID, REMAINING UNITS, WEEKEND

       

      So there can be many tasks with changing remaining units on each row.

       

      I have dimenisons. TASK and DISCLIPLINE. What i want to achive is sum the remaining units per week end by DISCLIPLINE and TASK. Then i can have a line chart over time that will SUM the remaining UNITS per week end by DISCIPLINE. I can also create a table visual that holds each task as a row and a week end as a column with the value being the sum of remaining units.

       

      Thanks

       

      Alex

      • Yossarian's avatar
        Yossarian
        Helper I
        3 years ago

        Hi AlexDawson111 ,

         

        As you're describing, the measure at hand should be just a SUM and if so it should work normallly on the table visual. On the other hand, it seems to me that the measure you are actually using is based on MAX.

         

        Adding to that, I am not sure how you set up your model - is DISCIPLINE on the same table as TASK ID or are they in separate tables? Maybe it is easier if you share a jpg of the model and of the measure you are using.

  • AlexDawson111's avatar
    AlexDawson111
    Frequent Visitor
    3 years ago

    Thanks for the reply, i have tried the following. 

     

    SUMX is too high  

     

     

    SUMMARIZE shows the following

     

     

    Thanks

    • Yossarian's avatar
      Yossarian
      Helper I
      3 years ago

      Hi AlexDawson111 ,

       

      Yes, when I said to summarize the table, it was for you to summarize the table inside the previous formula. Specifically:

       

      SUMX ( SUMMARIZE ( ... ), [Max of Remaining Labor Units] )

      See if it works. If it doesn't, please specify how you calculate this [Max of Remaining Labor Units] measure.