Income Statement Multiple Level Problem - PBID

[Moatasem]

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 : https://app.box.com/s/asgsn4b2ku885t94zmg68nzgykwyxktk

Any Help?

[igorabdo]

Hi Moatasem

Do you need help?