Forum Discussion
niemis
Helper I
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 ...
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])
)
bhanu_gautam
Super User
Super Userniemis , 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])
)