Create a boolean KPI based on categorical variable

[Anonymous]

Hi,

 Posting a subset of my dataset that looks like this:

Product Code	Type
abc1	Type1
abc1	Type2
abc2	Type1
abc3	Type2
abc5	Type1
abc5	Type2
abc7	Type1
abc8	Type2
abc8	Type1
abc10	Type2
abc11	Type1
abc11	Type2
abc13	Type1

In my report, I have a filter on the column Product code. 1 value can be selected at a time.

I want 2 KPIs called "Type1 "and "Type2"  which says "Yes" or "No"

The logic for KPI: If for a product code, there exists Type1 then "Type" 1 KPI says "Yes" else it says "No". Same logic for "Type2" KPI

2 Examples:

Product Code	abc1
Type1	Type2
Yes	Yes
Product Code	abc2
Type1	Type2
Yes	No

Note: A product code can be Type1 or Type 2 or both.

[TeigeGao · Accepted solution]

Hi @Anonymous ,

There is not a visual can display like your example, we can use multiple visual to display it, we cna create three measures to display these data:

Measure = IF(CALCULATE(MIN(Table1[Type]),FILTER(ALL(Table1),Table1[Product Code] = SELECTEDVALUE(Table1[Product Code]) && Table1[Type] = "Type1")) = BLANK(),"No","Yes")
Measure 2 = SELECTEDVALUE(Table1[Product Code])
Measure 3 = IF(CALCULATE(MIN(Table1[Type]),FILTER(ALL(Table1),Table1[Product Code] = SELECTEDVALUE(Table1[Product Code]) && Table1[Type] = "Type2")) = BLANK(),"No","Yes")

The result will like below:

Best Regards,

Teige