Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!Calling all Data Engineers! Fabric Data Engineer (Exam DP-700) live sessions are back! Starting October 16th. Sign up.
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
Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes!
Check out the October 2025 Power BI update to learn about new features.