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.

amitchandak's avatar
amitchandak
Super User
6 years ago

Anonymous 

#NULL Datecompleted =
VAR TotalRow = COUNTROWS(VALUES(swEqptHistory[WorkOrderID]))
Return
CALCULATE(TotalRow,FILTER(swEqptHistory,isblank(swEqptHistory[DateCompleted]) )
)

OR

#NULL Datecompleted =
VAR TotalRow = COUNTROWS(VALUES(swEqptHistory[WorkOrderID]))
Return
CALCULATE(TotalRow,FILTER(swEqptHistory,swEqptHistory[DateCompleted] == BLANK())
)

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Hi

     

    Unfortunately it still didnt work.  The output should be like below, i'm using manual input in filter pane.

     
    • amitchandak's avatar
      amitchandak
      Super User
      6 years ago

      Anonymous , try this setting too