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

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