Forum Discussion

mapko's avatar
mapko
Helper I
10 years ago

PnL: Vertical Analysis % issue

All,   I need to implement vertical analysis to my PnL statement.    My DAX query to calcualte the percentage is as follows:   Vertical = 'Profit & Loss Measures 1 Company'[Profit & Loss Value]...
Need Help
Greg_Deckler's avatar
Greg_Deckler
Community Champion
10 years ago

If you put the second part of your formula in your measure/column, what do you get? Seems like it is caculating to zero.

 

(CALCULATE(SUM('Profit & Loss Statement'[Profit & Loss Balance]),FILTER('Profit & Loss Statement','Profit & Loss Statement'[Profit & Loss Account Number]=1)))

What happens when you take out the filter?

 

Any chance you can share some sample data?

mapko's avatar
mapko
Helper I
10 years ago
For the revenue line it calculates the correct value. Other accounts are blank.