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, The below screenshot explains my issue. For some of my NoOverdue has no values which results blank Percentage values. which is why I'm not getting continues line graph. 

Sorry for the delayed respose. Many thanks

I get error when I try to create a variable with return function.