Dax to calculate % of Revenue

[Tihannah]

I've looked all over, but can't seem to find a solution for this. I'm working on Financial statements and need to get a % of Total Revenue for each sub category. The way my data is laid out I had to create a measure that filters for Actuals and Budget:

Actuals - 

 CALCULATE(SUM('Financials'[Amt]),FILTER('Financials','Financials'[Type_Cd] = "Act"))

Budget - 

 CALCULATE(SUM('Financials'[Amt]),FILTER('Financials','Financials'[Type_Cd] = "Bud"))

My accounts are set up the same way as a financial statement

I can easily just drop my Actual and Budget columns in again and select %ofTotal, which works fine, but to save real estate, I am creating "Budget"/ "Prior Year" buttons to toggle between for comparison vs Actual. So I need to create a dax that calculates % of Total Revenue for each account. Every example I've come across uses just a simple SUM(Sales[Sales]) type example, which doesn't work for the DAX I've had to create above to get these amounts. I feel like it shouldn't be this complicated, but I just keep hitting a wall with this. Any help is appreciated!

[MattAllington · Accepted solution]

P&Ls in Power BI are quite challenging. I have comprehensive coverage at my website

here https://exceleratorbi.com.au/build-a-pl-with-power-bi/

and

here https://exceleratorbi.com.au/building-a-pl-in-power-bi-part-2-percentages/

[Tihannah]

This was EXTREMELY helpful and helped me tackle several other things. Thank you!!

[MattAllington]

Great. I'm glad it helped.