cancel
Showing results for
Did you mean:
Frequent Visitor

## Minimum of distinct count per group

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

1 ACCEPTED SOLUTION
Super User

@Moht try this measure

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

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.

Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.

3 REPLIES 3
Super User

 Thanks to the great efforts by MS engineers to simplify syntax of DAX! Most beginners are SUCCESSFULLY MISLED to think that they could easily master DAX; but it turns out that the intricacy of the most frequently used RANKX() is beyond their comprehension! DAX is simple, but NOT EASY!
Super User

@Moht try this measure

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

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.

Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.

Frequent Visitor

thank you ! this works

Announcements

#### 2023 Release Wave 1 Plans

Power BI release plans for 2023 release wave 1 describes all new features releasing from April 2023 through September 2023.

#### Global Power BI Training

Make sure you register today for the Power BI Summit 2023. Don't miss all of the great sessions and speakers!

#### Business Application LATAM Summit 2023

Join the biggest FREE Business Applications Event in LATAM this February.

#### Global Power Platform Bootcamp

In this bootcamp we will deep-dive into Microsoft’s Power Platform stack with hands-on sessions and labs, delivered to you by experts and community leaders.

Top Solution Authors
Top Kudoed Authors