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 ar...
Need Help
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.