calculated subtotal in matrix

[Evandam]

hi,,

i was wondering if it is possible to add a calculated subtotal on a specific row in a matrix.

next to this i still have to be able to slice on team and / or project.

please find attached an example of the data and model.
example PBIX file 

[Jayee]

Hi @Evandam 

1. Create a custom table with structure you want with unique name something like below

Custom column in new table

Revenue

Cost

Revenue + cost

Margin

Overhead

Margin + Overhead 

Net profit

And create this column relationship to you description column

Create measures for each value you are using actual, budgets, delta and Use them in a visual.

Example measure = switch( Selected value( Custom Colum),

"Revenue + cost", calculate( sum(Actual), Description="Revenue")+ calculate ( sum( Actual), Description="Cost"),

Sum(Actual)

)

If this post helps, then please consider Accept it as the solution, Appreciate your Kudos!!

[Evandam]

@Jayee 

i tried to execute your suggested solution but unfortunatly i didnt work.


here is the pbix: pbix example file 

[Jayee · Accepted solution]

Hi @Evandam 

small tweek done on DAX formula now i can able to see the data 

Here the updated PBIX file link

If this post helps, then please consider Accept it as the solution, Appreciate your Kudos!!

[Evandam]

@Jayee exactly what i needed!! thanks!!