Forum Discussion

Sugumaran31's avatar
Sugumaran31
Helper I
2 years ago

Sub Total Calculation

Hi Guys, I need help from you Guys. I need to calculate the subtotal. please refer to the below images   eg: 1,2,3,....,12 is a serial no. Based on Serial No, I need to add a measure or column  ...
Need Help
Tips and Tricks
amitchandak's avatar
amitchandak
Super User
2 years ago

Sugumaran31 , Make sure Desc and PROW are coming from a dim table

 

example

Amount =
Switch( True()
, MAX ( Account[Account ID] ) = 4, CALCULATE([Revenue], filter(all(Account), Account[Account ID] in {1,2,3} ))
, MAX ( Account[Account ID] ) = 10, CALCULATE([Revenue], filter(all(Account), Account[Account ID] in {8,9,10} ))
[Total Amount]

)

 

 

Have explained the same in, additional table is optional , I used as I do not want change account table

 

Power BI How to get the P&L formatting right: https://youtu.be/C9K8uVfthUU
Power BI How to get two columns format Profit and Loss Statement(P&L) right: https://youtu.be/WLg85yiMgHI
https://medium.com/microsoft-power-bi/power-bi-formatted-p-l-with-custom-sub-totals-and-blank-rows-e39ca822908a