Forum Discussion
Filter NULL Value
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.
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
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
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.
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?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.