How to make GL Code 80018 capture at Table 3 ?

[admin11]

Hi All

I am creating a P&L report using PBI. 

Table 1 shown raw data have GL Code 80018 Amount 1,736,474.83

Table 2 shown GL code 80018 Capture at Fin Category Table

Total Sales = CALCULATE(SUM(GL_TI[C/D]),Fin_Category[Summary]="Sales")*-1

But Table 3 not display GL Code 80018 , only capture GL Code 80020 & 80026

Where go wrong ?

https://www.dropbox.com/s/dggq8vct4bot598/GL_WORKING%20v017%20ask_.pbix?dl=0

above link is my sample file.

Paul Yeo

[amitchandak]

@admin11 , You measure the Annual total causing that to remove. Can you check that calculation.  Not very sure what are trying to do there.