Forum Discussion
Helper IHow many ServiceNow Incidents do not have a knowledge article attached?
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:
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])
)
2 Replies
- bhanu_gautam
Super User
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])
) 
niemisbhanu_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