Forum Discussion
calculated subtotal in matrix
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
Hi Anonymous
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!!
4 Replies
Hi Anonymous
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!!
i tried to execute your suggested solution but unfortunatly i didnt work.
here is the pbix: pbix example fileHi Anonymous
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!!