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 :-
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 :-
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 ?