Why my matrix table return monthly wrong % amount and yet Total column return correct % amount

[admin11]

Hi All

I have a P&L summary table below :-

I notice that the Total column return correct value , but the monthly return wrong value . 

Remark :-

1. If both return wrong value , it is cause by expression error . 

Hope some one can share with me how to trouble shoot this problem ?

Value i insert below expression :-

PnL CY = SWITCH(SELECTEDVALUE('_PnL_Var'[PnL_Var]),

                            "1_REV", [_YTD_REV_N],

                            "2_COGS",[_YTD_COGS1],

                            "3_OTH", [_YTD_OTH_IN],

                            "4_EXP", [_YTD_EXP2],

                            "5_NET_P",[_YTD_NP_],

                            "6_GPM",[_YTD_GPM],

                            "7_NPM",[_YTD_NPM]

                            )

_YTD_GPM = DIVIDE([_YTD_REV_N]+[_YTD_COGS]+[_YTD_OTH_IN],[_YTD_REV_N])

_YTD_REV_N =

CALCULATE(

    SUM(GL[AMT])*-1,

    FILTER(

        GL,

        GL[1_REV]="REV"

    )

)

Paul

[lbendlin]

Please provide sanitized sample data that fully covers your issue. If you paste the data into a table in your post or use one of the file services it will be easier to assist you. I cannot use screenshots of your source data.

Please show the expected outcome based on the sample data you provided. Screenshots of the expected outcome are ok.

https://community.powerbi.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523

[admin11]

@lbendlin 

You are right , not easy to solve the issue by looking at the expression.

Hope that you can help me find out where go wrong ?

Paul

[lbendlin]

I don't see anything inherently wrong with the data.  ( I see a lot of nested measures which is always a red flag).  Why would you think that the GPM and NPM values are wrong?

[admin11]

@lbendlin 

Thank you for fast reply. in order to show you the error . i create a excel file.

you can download below link is excel file :-

https://www.dropbox.com/s/ntejaz7u7ax032z/PBI%20vs%20MANUAL.xlsx?dl=0

Paul