Forum Discussion

tarunbisht20001's avatar
tarunbisht20001
Frequent Visitor
2 years ago
Solved

Custom row level Total in Matrix

The client has requested a customization for the total calculations as follows: Total 1 should be the normal sum of the values. Total 2 should be calculated as Total 1 plus the sum of the va...
Need Help
Tips and Tricks
amitchandak's avatar
amitchandak
Super User
1 year ago

tarunbisht20001 , Seem like you want cumulative in subtotal , Assume the lowest level is product name and you are using a measure M1

 

Then

Switch(True() ,

isinscope(Table[Product Name]), [M1],

calculate([M1], filter(allselected(Table), Table[Level2] <= Max(Table2[Level 2])  ) )

)

 

You can consider window function for cumulative too

 

How to Switch Subtotal and Grand Total in Power BI | Power BI Tutorials| isinscope: https://youtu.be/smhIPw3OkKA

 

Continue to explore Power BI Window function Rolling, Cumulative/Running Total, WTD, MTD, QTD, YTD, FYTD: https://youtu.be/nxc_IWl-tTc
https://medium.com/@amitchandak/power-bi-window-function-3d98a5b0e07f