DAX help- Unique customer count basis on sales

[Anonymous]

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.

[Icey]

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.

[VahidDM]

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!!

[Anonymous]

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.

[VahidDM]

@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!!

[Anonymous]

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

[VahidDM]

@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!!

[Anonymous]

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 

[Anonymous]

Hi,

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

Thanks.