How to make My Expression display 4 GL Code Amount instead of 2 ONLY ?

[admin11]

Hi All

I have below expression working fine :- 

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

it can Shown 4 GL code Capture at Table 2 Fin Category Table

I have below expression , which only display 2 GL Code , 2 GL Code is missing :-

Anuual Total_2 =

VAR Summary = SELECTEDVALUE(Format_PnL[Sub Category])

VAR Category =SELECTEDVALUE(Format_PnL[Category])

RETURN SWITCH(TRUE(),

SELECTEDVALUE(Format_PnL[Sub Category])="GENERAL & ADMIN EXP",[Expense On General & Admin Expense],

CALCULATE([Total Profit],FILTER(GL_TI,GL_TI[GL Description]=Category)))

Can some one share with me where go wrong ?

Below is my PBI file :-

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

Paul 

[manikumar34]

@admin11 

Hi Paul, 

You need to chnage the relationship like the below. 

And use the below DAX

Anuual Total_2 =

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

Regards, 

Manikumar

[manikumar34 · Accepted solution]

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

Regards, 

Manikumar

[manikumar34]

@admin11 

Hi Paul,

You are getting only 2 rows on your second table beacuse you have filtered _REV to only REV. If you remove the filter, you will get many rows on the table.

Regards, 

Manikumar