Filter NULL Value

[Anonymous]

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

)

[Icey]

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]

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 · Accepted solution]

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]

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]

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]

Thanks a lot @Icey .

Cheers!

[amitchandak]

@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]

Hi

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

[amitchandak]

@Anonymous , try this setting too