Forum Discussion
calculated subtotal in matrix
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!!
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!!