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
Icon for Helper I rankHelper 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