Forum Discussion
Build Balance and P&L
- 4 years ago
I modify your final code:
IF ( MAX ( 'Report Balance'[Betreft] ) = "Balance", SWITCH ( TRUE (), MAX ( 'Report Balance'[Sortgroup] ) = MAX ( 'Report Balance'[Group 1] ), [GROUP_1], MAX ( 'Report Balance'[Sortgroup] ) = MAX ( 'Report Balance'[Group 2] ), CALCULATE ( SUMX ( ALLSELECTED ( 'Report Balance'[Sortgroup] ), [GROUP_1] ), FILTER ( ALL ( 'Report Balance' ), 'Report Balance'[Subtotal?] = 1 && 'Report Balance'[Sortgroup] < MAX ( 'Report Balance'[Sortgroup] ) && 'Report Balance'[Sortgroup] > Pre_Group2 ) ), [Total Balance] ), IF ( MAX ( 'Report Balance'[Subtotal?] ) = 1, SUMX ( FILTER ( ALL ( 'Report Balance' ), [Betreft] = "P&L" && [Sortgroup] < SELECTEDVALUE ( 'Report Balance'[Sortgroup] ) && [Subtotal?] = 0 ), [Total Balance] ), [Total Balance] ) )Did I answer your question ? Please mark my reply as solution. Thank you very much.
If not, please feel free to ask me.Best Regards,
Community Support Team _ Janey
Hello marsclone
If you check your data there are no values for Net Income. Once you updated the data then you can see the changes accordingly.
Thank You.
- marsclone4 years agoHelper IV
Hi Anonymous
You are correct that there are no values for Net Income, the values for "Gross Profit","EBITDA", .... , "Net Income" have to be calculated first. The current measure is not working properly, when this works then your measures come in place i think?
The outcome looks like this
Thank you!
- Anonymous4 years agoNot applicable
Hello marsclone
Could you please confirm is it working properly or not? If there is any issue could you please share the pbix file after removing the sensitive information? Also, please share the updated file and expected result.- marsclone4 years agoHelper IV
Hello Anonymous
The expected result should look like this
You are correct that there are no values for Net Income, the values for "Gross Profit","EBITDA", .... , "Net Income" have to be calculated first. The current measure is not working properly, when this works then your measures come in place i think?
Kind regards
Marcel