Aggregating Calculated Column as Row in Matrix

[Anonymous]

I have the below matrix. The issue is that the 90 Day column isnt showing the total, its showing only 1 day. Does anyone know if there is a workaround?

The request is to show the 90 Day total, but not to breakout it out by the TS Period columns however it isn't aggregating. I tried making 90 Day a measure, but then it wouldnt let me add it to the Rows area in the visual.

Visual breakout:

Rows-

Proj_ID

Project Name

Title

Employee Name

PYTD Util (calc Column)

90 Days (calc Column)

Columns:

TS Period

Values:

Goal Hours

Actual Hours

Holiday Hours

Variance Actual- Goal

Variance %

[v-frfei-msft]

Hi @Anonymous ,

Kindly share your sample data and excepted result to me if you don't have any Confidential Information. Please upload your files to One Drive and share the link here.

[Anonymous · Accepted solution]

I cant share unfortunatly, however I figured this out.

Matrixes rows automatically group like numbers together instead of using the aggregation that was set for that column.

To solve this I had to create a seperate table which grouped the sum total by Employee ID in query editor that I needed and then added that total from query editor into my matrix.