Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Is Blank DAX

Hi, I've below DAX but I'm not getting continues line on visual. How to input 0 if my values are blank/missing.   I"m doing Count of ID from CM table with filtered by Not Overdue from [Overdue / N...
Need Help
  • Anonymous's avatar
    Anonymous
    5 years ago

    This one fixed my problem.

    % Completion = if(ISBLANK([NotOverDue])&& NOT(ISBLANK([Overdue_CM])),0,
    CALCULATE(COUNT(CM[ID]),CM[Overdue / Not overdue]="Not Overdue")/CALCULATE((COUNT(CM[ID]))))
Anonymous's avatar
Anonymous
Not applicable
5 years ago

Hi Anonymous ,

Could you tell me if your problem has been solved?
If it is, kindly Accept it as the solution. More people will benefit from it.
Or you are still confused about it, please provide me with more details about your table and your problem or share me with your pbix file from your Onedrive for Business.


Best Regards,
Stephen Tao