Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Filter NULL Value

Hi Guys   I'm trying to filter my datecompleted = NULL by using below dax, unfortunately it didn't help. Could anyone pls advise if anything wrong with my dax?  #NULL Datecompleted = VAR To...
Need Help
  • Icey's avatar
    Icey
    6 years ago

    Hi Anonymous ,

     

    Try to create a measure like below:

    Measure = CALCULATE(COUNT(Table1[WorkOrderID]),Table1[DateCompleted]=BLANK())

     

    Best Regards,

    Icey

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Thanks Icey , it works. However, i have another question. Instead of count, i just want to filter the rows that datecomplete = blank().

i tried using this 

CALCULATE(FILTER(swEqptHistory,swEqptHistory[DateCompleted] = 0),swEqptHistory[WorkOrderID]) but didnt work. Can you advise?


Icey's avatar
Icey
Community Support
6 years ago

Hi Anonymous ,

 

It is suggested to use a Filter or Slicer.

 

 

Best Regards,

Icey

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Thanks a lot Icey .

     

    Cheers!