Check values in null in dax with filtered values

[mehaboob557]

Hi All,

I am new to PBI.

Here is my pbix file

I have used the one measures(you can find the in the pbix file Appliances data). i need to get the data  where condition is item type should be "product" and inv_caegory should be "Appliances" . yu can find the values in table3

Now i need to calculate YES or NO within the filtered values,

1.If purchase_sales_order is empty.. i need to set status YES Elese NO

I have to add this status(i.e YES or NO) in table 1 after party_name

How can i achieve this. Please help me 

Thanks in advance.

[mehaboob557 · Accepted solution]

I have used the Below Measure to achieve,

count three = COUNTBLANK('gubbi_ods erp_so_details'[purchaseorder_no] )

the above count will be counting the blank one and i am adding the item_type an dinv_category what ever i need to filter it in above measure.

Then i am using below measure to achieve.

Measure4 = IF(SUMX(ADDCOLUMNS(CROSSJOIN(VALUES('gubbi_ods erp_so_details'[salesorder_no]),VALUES('gubbi_ods erp_so_sourcing'[main_line_item])),"HA",IF(ISBLANK('gubbi_ods erp_so_details'[Count three]),BLANK(),IF([Count three]=0,BLANK(),1))),[HA])<1,"RAISED","NOT RAISED")

[v-chuncz-msft]

@mehaboob557,

Simplify your model as much as possible so that it could be easier for us to have a test.