How many ServiceNow Incidents do not have a knowledge article attached?

[niemis]

I am trying to create two reports, one that counts the number of Incidents with knowledge article(s) attached, and one that counts the number of Incidents without knowledge attached.  

I'm using 2 tables, the Incident and the m2m_kb_task table.  The relationship is a many to many from the m2m_kb_task/task to incident/sys_id with cross filter in both directions. 

I have been trying multiple measures but I am missing something.  It seems no matter what I try, I am only getting counts for incidents that have knowledge attached. 

I am hoping someone can help me see where I am going wrong.  I would greatly appreciate it.  

Here is one example of a measure I'm using:  

Number of Incidents without Knowledge Articles =

COUNTROWS(

    FILTER(

        incident,

        ISBLANK(CALCULATE(

            DISTINCTCOUNT(m2m_kb_task[task]),

            RELATEDTABLE(m2m_kb_task)

        ))

    )

)

[niemis]

@bhanu_gautam Thank you so much.  I also tried something similar to this, and the count was blank.  It could be very well that ALL incidents have at least one knowledge article attached.  

Sally

[bhanu_gautam · Accepted solution]

@niemis , Create two measure

Measure for Incidents with Knowledge Articles:DAX
Number of Incidents with Knowledge Articles =
CALCULATE(
DISTINCTCOUNT(incident[sys_id]),
NOT(ISBLANK(m2m_kb_task[task]))
)

Measure for Incidents without Knowledge Articles:

DAX
Number of Incidents without Knowledge Articles =
CALCULATE(
DISTINCTCOUNT(incident[sys_id]),
ISBLANK(m2m_kb_task[task])
)