Showing results for 
Search instead for 
Did you mean: 
Regular Visitor

Income Statement Multiple Level Problem - PBID

Hi All,


I watched a video describing how to build an income statment (P&L) inside MS Excel using PowerPivot, I followed the steps and every thing was fine


Data Model


Report with PowerPivot / Excel



in this report "Gross Profit" GP stored in DimHeaders[Header], the GP value is calculated as a running total -there aren't any transactions in FactNetIncome with the label Gross Profit or its Account Key


Dollars w Sign RT:=
CALCULATE( [Dollars w Sign];
    FILTER( all( Dimheaders );
        DimHeaders[Order] <= MAX( DimHeaders[Order] )


The problem is
When I started to rebuild the P&L in Power BI Desktop, the report -table visual- with the Header column only works fine (left table below) , but when I insert the next level "SubHeader1" (right table) I got two lines for GP first with Blank and the second with Sales Revenue, my expectation was getting one line for GP with the running total




Headers Table



PBID File :

Any Help?

igorabdo Advocate II
Advocate II

Re: Income Statement Multiple Level Problem - PBID

Hi Moatasem

Do you need help?

Helpful resources

Announcing the New Spanish Forum

Announcing the New Spanish Forum

Do you need help in Spanish? Check out our new Spanish community section.

MBAS Gallery 2020

MBAS Gallery 2020

Watch Microsoft Business Applications Summit sessions on-demand.

‘Better Together’ Integration Forum Launch

‘Better Together’ Integration Forum Launch

We've launched a how-to forum where you can learn about how Power BI integrates with other Power Platform products.

Top Solution Authors
Top Kudoed Authors