Totals Summing All Table

[AlexDawson111]

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

[AlexDawson111]

Thanks for the reply, i have tried the following. 

SUMX is too high  

SUMMARIZE shows the following

Thanks

[Yossarian]

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.

[Yossarian]

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]

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]

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.