topic Re: Number of customers commandes > 2 in a week in DAX Commands and Tips

Number of customers commandes > 2 in a week

Sofinobi — Thu, 27 Apr 2023 13:18:05 GMT

hi community,

please if you can help, i want to calculate the number of customers that have more than 2 commandes in a week
that i can display in a matrice by Région as in the Pbix file attached

thank you
Nbr_Commande

Re: Number of customers commandes > 2 in a week

Sofinobi — Sun, 30 Apr 2023 12:28:15 GMT

🤔

Re: Number of customers commandes > 2 in a week

Anonymous — Mon, 01 May 2023 08:56:50 GMT

Hi Sofinobi ,

I suggest you to try this code as below to create a measure.

Count Customer = VAR _SUMMAIRZE = SUMMARIZE ( ALLEXCEPT ( Tableau1, Tableau1[Date] ), Tableau1[Région], Tableau1[Customer], "nbr commande", [nbr commande] ) RETURN COUNTAX ( FILTER ( _SUMMAIRZE, [Région] = MAX ( Tableau1[Région] ) && [nbr commande] > 2 ), [Customer] )

Due to your sample only have last week data, so I change the date filter to show last week value.

Also in your sample only have customers whose commandes >=2, I change the filter to show values [nbr commande]>=2 to have a test. Result is as below.

Best Regards,

Rico Zhou

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Re: Number of customers commandes > 2 in a week

Sofinobi — Tue, 09 May 2023 18:00:34 GMT

thank you so much for you answer , that works
and sorry to be late, cause i was in an other project;

thank you again