Advance your Data & AI career with 50 days of live learning, dataviz contests, hands-on challenges, study groups & certifications and more!
Get registeredGet Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Request now
Below is the source coloumn and goal is to count 1 if the unique items for ID exceeds 2 over a week. Here in Week1 The unique items were 2 so it will be considered 0 and in week2 the unique items exceeded 2 and will be counted as 1.
| ID | Item | Week |
| 100 | Shoe | Week1 |
| 100 | T-Shirt | Week1 |
| 100 | T-Shirt | Week1 |
| 100 | T-Shirt | Week1 |
| 100 | Shoe | Week2 |
| 100 | T-Shirt | Week2 |
| 100 | Cap | Week2 |
| 100 | Shoe | Week2 |
| 100 | Belt | Week2 |
So here unique items for ID exceeded in Week 2 So the result will be below
ID Result
100 1
Solved! Go to Solution.
@datadog_ab
Create a measure as follows:
Result =
COUNTROWS(
FILTER(
ADDCOLUMNS(
SUMMARIZE( Table01 , Table01[Week] ),
"@count" , CALCULATE( DISTINCTCOUNT( Table01[Item] ) )
),
[@count] > 2
)
)
⭕ Subscribe and learn Power BI from these videos
⚪ Website ⚪ LinkedIn ⚪ PBI User Group
@datadog_ab
Create a measure as follows:
Result =
COUNTROWS(
FILTER(
ADDCOLUMNS(
SUMMARIZE( Table01 , Table01[Week] ),
"@count" , CALCULATE( DISTINCTCOUNT( Table01[Item] ) )
),
[@count] > 2
)
)
⭕ Subscribe and learn Power BI from these videos
⚪ Website ⚪ LinkedIn ⚪ PBI User Group
Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!
Check out the October 2025 Power BI update to learn about new features.