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 TotalRow = COUNTROWS(VALUES(swEqptHistory[WorkOrderID]))
Return
CALCULATE(TotalRow,FILTER(swEqptHistory,swEqptHistory[DateCompleted] = BLANK())
)
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.

9 Replies

  • 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.

       
  • Icey's avatar
    Icey
    Community Support
    6 years ago

    Hi Anonymous ,

     

    Is this problem solved?


    If it is solved, please always accept the replies making sense as solution to your question so that people who may have the same question can get the solution directly.


    If not, please share me a dummy .pbix file, removing sensitive information. It is suggested to upload your file to OneDrive for Business and then paste the link here.

     


    Best Regards,
    Icey

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      Hi Icey

       

      unfortunately it still cant get the desired result. I need to get the count of WorkorderID which datecompleted = NULL. I had exported out part of my data in XLXS format. Appreaciate if u can help. 

      the end result should be below SS when i used filter pane.

       

       

       

      https://1drv.ms/x/s!Au9T7Qp34vJEjRFcmMn0swfEkOS1?e=dbB1pr

      • Icey's avatar
        Icey
        Community Support
        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.