topic Re: show and compare unique name to overall name in DAX Commands and Tips

show and compare unique name to overall name

Anonymous — Tue, 07 Jun 2022 01:05:02 GMT

Hi,

I have list of customers, some of them had buy something (I call them 'active customer') and the others not. I want to show and compare how many active customer to overall customer in my database. Any advise how to do it in power bi?

Thank you

Re: show and compare unique name to overall name

amitchandak — Tue, 07 Jun 2022 03:07:11 GMT

Anonymous , Not very clear. But approach in the blog can help

Customer Retention Part 1:
https://community.powerbi.com/t5/Community-Blog/Customer-Retention-Part-1-Month-on-Month-Retention/ba-p/1361529
Customer Retention Part 2: Period over Period Retention :https://community.powerbi.com/t5/Community-Blog/Customer-Retention-Part-2-Period-over-Period-Retention/ba-p/1377458

Customer Retention Part 5: LTD Vs Period Retention
https://community.powerbi.com/t5/Community-Blog/Customer-Retention-Part-5-LTD-and-PeriodYoY-Retention-is-only/ba-p/2114497

Re: show and compare unique name to overall name

Anonymous — Tue, 07 Jun 2022 08:34:24 GMT

Hi,

Thank you for your support. Please allow me to reexplain my question.

I have 2 files, one is database of people who register in my website and the other one is the order book.

I would like to show how many people who had order something in past 1 year then compare to overall registered user.

Hope this clear enough. Thank you

Re: show and compare unique name to overall name

v-xiaotang — Thu, 09 Jun 2022 09:48:26 GMT

Hi Anonymous

You can try this measure,

Measure = var _TY= YEAR(TODAY()) var _countLY= CALCULATE(COUNTROWS('order'),FILTER('order',YEAR('order'[order date])=_TY-1)) var _allusers=COUNTX(register,register[user]) return DIVIDE(_countLY,_allusers)

Best Regards,

Community Support Team _Tang

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