Hi
I have a table with columns: ID, Order sale and Product.
I need a mesure than count the number of Order sale that have iqual or more than 2 product.
The photo of down resum the idea between the table, dynamic table and the mesure that count the number of order sale greater than 2.
1 ACCEPTED SOLUTION
Hi,
try this measure:
Measure = var flag = CALCULATE(COUNT('Table'[Order Sale]))>=2
return
if(flag=TRUE(),CALCULATE(DISTINCTCOUNT('Table'[ID])),0)
If I answered your question, please mark my post as solution, Appreciate your Kudos 👍
Hi,
try this measure:
Measure = var flag = CALCULATE(COUNT('Table'[Order Sale]))>=2
return
if(flag=TRUE(),CALCULATE(DISTINCTCOUNT('Table'[ID])),0)
If I answered your question, please mark my post as solution, Appreciate your Kudos 👍
Helpful resources
Power BI Monthly Update - September 2025
Check out the September 2025 Power BI update to learn about new features.
FabCon Atlanta 2026
Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
