Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Solved! Go to 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!!
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!!
i tried to execute your suggested solution but unfortunatly i didnt work.
here is the pbix: pbix example file
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!!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
112 | |
100 | |
80 | |
64 | |
57 |
User | Count |
---|---|
146 | |
110 | |
93 | |
84 | |
67 |