How to make P&L INDEX 3 , 10 , 12 don't appear ?

[admin11]

Hi All

I have a P&L file from @VijayP working fine , it can display index  2 , 3 , 10 , 12 , 14 which is correct.

Below link is working PBI file :-

https://www.dropbox.com/s/2p3mymck583aumc/GL_WORKING.pbix?dl=0

I try to do duplicate above , INDEX 3 , 10 , 12 don't appear ?

Have check :-

- All table and field are both same.

- Compare the link between all table are similar.

- Have check index 3 10 12 appear at Table B.

Below is my PBI file :-

https://www.dropbox.com/s/h10ks9th3lh1i06/GL_NOT_DISPLAY_COGS.pbix?dl=0

i suppect it is due to expression on Total Sales_1 :-

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

I have try to check the Table , it does have value label " SALES ". But index 3 on ward still refuse to come out.

what else i should check ?

Paul 

[jdbuchanan71]

@admin11 

It looke like those 3 indexes are not appearing becasue the GL accounts they are assigned to in the Formt_PnL table have no values in the GL_TI table.

[admin11]

@jdbuchanan71 

Below link is working PBI file :-

https://www.dropbox.com/s/2p3mymck583aumc/GL_WORKING.pbix?dl=0

i have 2 PBI File , both are load with same raw data. Above PBI able to display all Index . 

my PBI file I try to duplicate by create by myself . The issue is Cause by the Total Sales expression suppose pick up those sub category amount for index 3 onward, This PnL only have 3 table , but the linkage look simple , yet I cannot figure where go wrong ?