column sub total incorrect in power bi metrix table, please assist

[DEEW]

Operating responsibility	Week commence 31/7/2023	Week commence 07/08/2023	Week commence 14/08/2023	Week commence 21/08/2023	Week commence 28/08/2023	Total ( is showing incorrect figures)
HME& Tech	27	21	15	9	6	30 ?
PMO West	46	37	28	19	14	48?
PMO East	30	23	15	10	8	33 ?

[v-rongtiep-msft · Accepted solution]

Hi @DEEW ,

Is this value a MEASURE formula? If so, please have a try.

Create a measure based on the value meaure.

_result_ = var _a = 'table'[value_]
var _b = SUMMARIZE('table','table'[operating responsibility],"aaa",'table'[value])
return
IF(HASONEVALUE('table'[operating responsibility]),_a,SUMX(_b,[aaa]))

You can change the 'table'[operating responsibility] column to a unique value, like index, date and so on.

How to Get Your Question Answered Quickly 

If it does not help, please provide more details with your desired output and pbix file without privacy information (or some sample data) .

Best Regards
Community Support Team _ Rongtie

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[DEEW]

Thanks for reply. 

yes the value is a measure 

M_Employee DCount = CALCULATE(DISTINCTCOUNT('Table_hrs_by_calendar_day'[R3445_EmployeeId]), NOT(ISBLANK('Table_hrs_by_calendar_day'[Actual Dates])))

Can you please explane the DAX a bit more.. what did you mean by"aaa".