Same value is reflecting from previous PC while comparing PC wise data

[manikumar34]

Hello,

I am comparing PC wise data on my dataset. I have the C OIL 200 in my Last PC data whereas I don't have the C OIL 200 in my SUB SUB GROUP in current PC. So, it should be blank for Present PC or Null but it is reflecting the LastPC value. 

Please help me regard this .

I want to show the value as "0" or Blank. 

Thanks in Advance. 

[v-chuncz-msft]

@manikumar34 

You may check if the following posts help.

• https://community.powerbi.com/t5/Desktop/Students-variations-year-over-year/m-p/345749#M155124
• https://community.powerbi.com/t5/Desktop/Percentange-Difference-on-selected-Years-only/m-p/589960#M2...

[manikumar34]

no,it's not helpful.

Let me help you with my DAX

Current PC Contribution Per Ton =

var _num= SUMX(Sheet1,IF(Sheet1[pc_finyr]=MAX(Sheet1[pc_finyr]),(Sheet1[Total Sales]+Sheet1[Discount]+Sheet1[ Total Cost ]+Sheet1[NR Expenses]+Sheet1[Ttl Prov]+Sheet1[ Manufacturing Contribution/Royalty of Chandrika ]),0))

var _den = SUMX(Sheet1,IF(Sheet1[pc_finyr]=MAX(Sheet1[pc_finyr]),Sheet1[Qty in Ton Adjusted],0))

return

IF(_num=0,0,DIVIDE(_num,_den))

Previous  PC Contribution Per Ton =

var _num= SUMX(Sheet1,IF(Sheet1[pc_finyr]=MIN(Sheet1[pc_finyr]),(Sheet1[Total Sales]+Sheet1[Discount]+Sheet1[ Total Cost ]+Sheet1[NR Expenses]+Sheet1[Ttl Prov]+Sheet1[ Manufacturing Contribution/Royalty of Chandrika ]),0))

var _den = SUMX(Sheet1,IF(Sheet1[pc_finyr]=MIN(Sheet1[pc_finyr]),Sheet1[Qty in Ton Adjusted],0))

return

IF(_num=0,0,DIVIDE(_num,_den))

Here the value is taking where the SUB SUB GROUP is not at all present in the database for the current PC. 

[manikumar34]

@v-chuncz-msft  Please look into the above message and help me according

[manikumar34 · Accepted solution]

It was due to I had used SUMX and comparing both previous and current values on the same Matrix. Tweaked the DAX a little to avoid this issues.