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,

Both approachs are not working.

1st one had no changes

2nd one all value remains zero. any other help?

amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
5 years ago

Anonymous ,Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.