Filter the measure based on the other measure value

Question

Please help me I am trying to filter out the data in 23 Qty Blank Values Only Based on the check Month Wise .

Check Month Wise = IF(ISBLANK([23 Qty]),"D",IF(ISBLANK([22 Qty]),"N",BLANK()))

This is a Measure.

I have tried this dax

23 Qty Blank Values Only = If( check Month Wise=Blank(), 23 Qty,0) 

But its not working subtotal level its getting item code level only 

Please find the Image here

In the subtotal level also filter the values

Answer 1

You will need to use SUMX so that it is calculated per row of your relevant table.

Try something similar to:

23 Qty Blank Values Only = 
  SUMX(
    DISTINCT('Financial Data Month'[PAC ITEM CODE]),
    IF(ISBLANK( [Check] ), [23 Qty], 0)
  )