cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
mehaboob557 Member
Member

Check values in null in dax with filtered values

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.

1 ACCEPTED SOLUTION

Accepted Solutions
mehaboob557 Member
Member

Re: Check values in null in dax with filtered values

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")
2 REPLIES 2
Community Support Team
Community Support Team

Re: Check values in null in dax with filtered values

@mehaboob557,

 

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

Community Support Team _ Sam Zha
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
mehaboob557 Member
Member

Re: Check values in null in dax with filtered values

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