Minimum of distinct count per group

[Moht]

Hello Experts 🙂

I need help figuring out this head knot , in a table i have columns representing , week_num , day , product , sales 
I'm trying to calculate a measure with , for each week , the minimum of distinct product sold in one day of that week 

data table : 

Week	day	product
W1	12/2	A
W1	12/2	B
W1	13/2	A
W2	14/2	C
W2	14/2	C
W2	14/2	C

the result would be :

Week	Cacl
W1	1
W2	3

i hope my question is not too unclear, 
thank you so much 

[CNENFRNL]

[parry2k · Accepted solution]

@Moht try this measure

M = MINX ( SUMMARIZE ( WeekTable, WeekTable[Week], WeekTable[day], "@Count", COUNTROWS ( WeekTable) ), [@Count] )

✨ Follow us on LinkedIn and  to our YouTube channel

I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make effort to give Kudos to whoever helped to solve your problem. It is a token of appreciation!

⚡ Visit us at https://perytus.com, your one-stop shop for Power BI-related projects/training/consultancy.

[Moht]

thank you ! this works