Forum Discussion

GuestUser's avatar
GuestUser
Helper V
6 years ago

Report Table View Issue

Hi ,

In contination to this thread
https://community.powerbi.com/t5/Service/Profit-and-Loss-Reports/td-p/887396/page/2

 

i have dragged Level columns from Dimension table (level 5 and Level 6)
I need only one row (total row) for Profit before depreciation..is there any way to achieve it in table view?

 

In matrix view -- i did and it is working properly (used +/- icon and hidded extra rows) but since download to excel does
not keep the same format, hence we are making it in table view

 

 So can u pls suggest if it is possible? to have only one total row for Profit before depreciation and Profit after
depreciation in table view

Need Help

9 Replies

  • Icey's avatar
    Icey
    Community Support
    6 years ago

    Hi GuestUser ,

     

    Is this what you want?

    P&L Schema Amount =
IF (
    HASONEVALUE ( 'P&L Schema'[P&L] ),
    SUMX (
        SUMMARIZE (
            'P&L Schema',
            'P&L Schema'[P&L],
            'P&L Schema'[Account ID],
            'P&L Schema'[Weight],
            "@Sum Amount", SUM ( 'Fact'[Amount] )
        ),
        [@Sum Amount] * 'P&L Schema'[Weight]
    ),
    SUMX (
        FILTER (
            SUMMARIZE (
                'P&L Schema',
                'P&L Schema'[P&L],
                'P&L Schema'[Account ID],
                'P&L Schema'[Weight],
                "@Sum Amount", SUM ( 'Fact'[Amount] )
            ),
            [P&L] = "Profit before depreciation"
                || [P&L] = "Profit after depreciation"
        ),
        [@Sum Amount] * 'P&L Schema'[Weight]
    )
)

     

     

    Best Regards,

    Icey

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.