topic DAX help- Unique customer count basis on sales in DAX Commands and Tips

DAX help- Unique customer count basis on sales

Anonymous — Sun, 17 Oct 2021 04:53:53 GMT

Hello Experts,

Need help on this.

I have compare count unique customers based on their sales >0 after launch months onwards as summary have given below.

Tanushree_Kapse VahidDM GregM amitchandak - Please help me on this.

Thanks a ton in advance.

Re: DAX help- Unique customer count basis on sales

VahidDM — Mon, 18 Oct 2021 04:34:07 GMT

Hi Anonymous

Can you add more details about the calculation? how did you create the result table in Excel? can you share the Excel formula?

Appreciate your Kudos!!

Re: DAX help- Unique customer count basis on sales

Anonymous — Mon, 18 Oct 2021 04:59:14 GMT

Hi,

Thanks for reply.

Actually , I have to count distinct of customer code from launch month to last months but we have to check sales >0 every month at customer level total sales

For example.

customore abc is purchased in launch month jan21 but not purchased in feb21 and again purchased in last month- hence then unique count will be 1 but it purchased 2 times.

Summary will be like abc customer is in north zone then

Zone launch month purchase 2 times purchase 3 times purchase >3 times

North 0 1 0 0

I Hope it will help

VahidDM Tanushree_Kapse amitchandak Greg_Deckler

Thanks.

Re: DAX help- Unique customer count basis on sales

VahidDM — Mon, 18 Oct 2021 05:31:21 GMT

Anonymous

If abc is purchased in launch month jan21 why in the result table launch month purchase is Zero?

Zone launch month purchase 2 times purchase 3 times purchase >3 times

North 0 1 0 0

Appreciate your Kudos!!

Re: DAX help- Unique customer count basis on sales

Anonymous — Mon, 18 Oct 2021 05:36:16 GMT

Sorry type error, It should count 1 in launch month as well as in 2 times purchase column.

Thanks.

Zone launch month purchase 2 times purchase 3 times purchase >3 times

North 1 1 0 0

Re: DAX help- Unique customer count basis on sales

VahidDM — Mon, 18 Oct 2021 05:42:35 GMT

Anonymous

Can you change your data structure? Unpivot all month columns.

https://support.microsoft.com/en-us/office/unpivot-columns-power-query-0f7bad4b-9ea1-49c1-9d95-f588221c7098

Appreciate your Kudos!!

Re: DAX help- Unique customer count basis on sales

Anonymous — Mon, 18 Oct 2021 05:46:18 GMT

Hi,

Data is in row level (inpivot). I had given the sample data set which i use in excel for working.

Thanks.

Re: DAX help- Unique customer count basis on sales

Anonymous — Mon, 18 Oct 2021 13:52:59 GMT

Hi,

I have done 90% of work by help of summarize funtion.

but one point on which I am stucking is that for example

Customer	Sales	Month
abc1	2202	Jan-21
abc2	1043	Jan-21
abc3	1576	Jan-21
abc1	0	Feb-21
abc2	1211	Feb-21
abc3	2989	Feb-21
abc1	1209	Mar-21
abc2	0	Mar-21
abc3	2036	Mar-21
abc4	1279	Mar-21
abc1	2258	Apr-21
abc2	0	Apr-21
abc3	320	Apr-21
abc4	2050	Apr-21

Summary will be
	Retention customer Count
Measure	Feb-21	Mar-21	Apr-21
Unique Cust count	2	2	3

** Retention means customers who have purchased at leat 1 time in any previous month.

I am not able to compare the customer wise sales in all previous months to get this result.

Please help me on this.

Thanks

amitchandak Greg_Deckler Tanushree_Kapse AlexisOlson Jihwan_Kim PBICommunity

Re: DAX help- Unique customer count basis on sales

Icey — Tue, 26 Oct 2021 08:19:36 GMT

Hi Anonymous ,

Please check my reply in your another post: Re: Need help on custom report - Microsoft Power BI Community.

Best Regards,

Icey

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