Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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.
Solved! Go to 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
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