Help with KPI

[rvijayanth]

I have a dimension called "Priority" with three possible values:

CatA

CatB

CatC

1. I have a table with dimension Priority and count of it as a measure

2. Then we also have three KPIs: like shown below:

count({$<[Priority] = {CatA}>} distinct CASE_ID_INT)

count({$<[Priority] = {CatB}>} distinct CASE_ID_INT)

count({$<[Priority] = {CatC}>} distinct CASE_ID_INT)

Question:

If I select Priority CatB in table, I expect the first and third KPIs to become Zero. buts not. What am I doing incorrectly?

[sunny_talwar · Accepted solution]

Try this

Count({$<[Priority] *= {CatA}>} DISTINCT CASE_ID_INT)

Count({$<[Priority] *= {CatB}>} DISTINCT CASE_ID_INT)

Count({$<[Priority] *= {CatC}>} DISTINCT CASE_ID_INT)

[rvijayanth]

Thank you so much. Can you explain what the modifier * does in this expression?

[sunny_talwar]

Check this link out:

Implicit Set Operators

[rvijayanth]

Thanks