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]))))
AllisonKennedy's avatar
AllisonKennedy
Icon for Community Champion rankCommunity Champion
5 years ago

Anonymous  You can always just add 0 to the measure, but this will impact how it behaves with filters and will show 0 for any scenario where values are blank/missing (which is what you asked) but if you want to apply other filters, just come back with more info and we can help.

 

My Current DAX: 

CALCULATE(count(CM[ID]),CM[Overdue / Not overdue]="Not Overdue") / CALCULATE((COUNT(CM[ID]))) + 0