Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
Evandam
Helper II
Helper II

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.

 

Schermafbeelding 2022-11-19 210328.jpg

 

 

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

1 ACCEPTED SOLUTION
Jayee
Responsive Resident
Responsive Resident

Hi @Evandam 

 

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

Jayee_0-1669011862310.png

 

Here the updated PBIX file link

 

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

View solution in original post

4 REPLIES 4
Jayee
Responsive Resident
Responsive Resident

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!!

@Jayee 

 

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


here is the pbix: pbix example file 

Jayee
Responsive Resident
Responsive Resident

Hi @Evandam 

 

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

Jayee_0-1669011862310.png

 

Here the updated PBIX file link

 

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

@Jayee exactly what i needed!! thanks!!

 

 

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

July Newsletter

Fabric Community Update - July 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors