Sum for categories in adjacent column

[JoeyI]

Hi,

How can i get the sum duration for each Id on the different date and shifts?

Thanks

[Anonymous]

SUMMARIZE(Table_Shifts , ROLLUP( [shift date], [shift type],[I'd]) , "Duration", SUM(Table_Shifts[Duration])  )

[JoeyI]

Hello @Anonymous , what am i missing?

[v-juanli-msft]

Hi @JoeyI 

As suggested by az38, please add columns in a matrix.

Best Regards
Maggie
Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[JoeyI]

Hello @v-juanli-msft  ,

What i wanted to do was get them by Date/shift and use the resulting values in a measure.

[v-juanli-msft]

Hi @JoeyI 

Do you try to add columns to a matrix as above?

Is there any problem?

Best Regards

Maggie

[JoeyI]

Hello @v-juanli-msft ,

I have added a matrix on the report as you asked.

But i dont require it on my report. wanted to apply a measure on it before reporting the resulting figures

[az38]

Hi @JoeyI 

if I understand you correct

Measure = CALCULATE(SUM(Table[Duration], ALLEXCEPT(Table, Table[Id], Table[Shift Date]) )

[JoeyI]

Hello @az38 , thanks for the feedback.

How do i get it in a table like this?

[az38]

@JoeyI 

the easiest way is to create a matrix visual, add Date and Shift as rows, Shift Time as columns, Duration as Values (check if it is aggregated as Sum)

then in matrix settings set Row headers - Stepped Layout = Off, then Row subtotals = Off