Filter the measure based on the other measure value ❤️ {UPDATED 2023}

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

In the subtotal level also filter the values

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)
  )