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

Question

Hi AllI have a P&amp;L summary table below :-&nbsp;I notice that the Total column return correct value , but the monthly return wrong value .&nbsp;&nbsp;Remark :-1. If both return wrong value , it is cause by expression error .&nbsp;&nbsp;Hope some one can share with me how to trouble shoot this problem ?&nbsp;Value i insert below expression :-PnL CY = SWITCH(SELECTEDVALUE('_PnL_Var'[PnL_Var]),&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; "1_REV", [_YTD_REV_N],&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; "2_COGS",[_YTD_COGS1],&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; "3_OTH", [_YTD_OTH_IN],&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; "4_EXP", [_YTD_EXP2],&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; "5_NET_P",[_YTD_NP_],&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; "6_GPM",[_YTD_GPM],&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; "7_NPM",[_YTD_NPM]&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; )&nbsp;_YTD_GPM = DIVIDE([_YTD_REV_N]+[_YTD_COGS]+[_YTD_OTH_IN],[_YTD_REV_N])&nbsp;_YTD_REV_N = CALCULATE(&nbsp; &nbsp; SUM(GL[AMT])*-1,&nbsp; &nbsp; FILTER(&nbsp; &nbsp; &nbsp; &nbsp; GL,&nbsp; &nbsp; &nbsp; &nbsp; GL[1_REV]="REV"&nbsp; &nbsp; ))&nbsp;Paul

lbendlin · Answer

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 · Answer

lbendlin&nbsp;You are right , not easy to solve the issue by looking at the expression.&nbsp;Hope that you can help me find out where go wrong ?&nbsp;Paul

lbendlin · Answer

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

admin11 · Answer

lbendlin&nbsp;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 :-&nbsp;https://www.dropbox.com/s/ntejaz7u7ax032z/PBI%20vs%20MANUAL.xlsx?dl=0&nbsp;Paul&nbsp;

Forum Discussion

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

4 Replies

Related content

Monthly Automatic Change

Correcting Data

Dax Formula correction help

Dax correction

Monthly Count not working