Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
114 | |
99 | |
83 | |
70 | |
61 |
User | Count |
---|---|
149 | |
114 | |
107 | |
89 | |
67 |