Find out how many users have purchased products

ninu — Thu, 15 Feb 2024 20:54:23 GMT

Hi all,

I am trying to find out how many users have purchased products and plot in a visual to give an idea about the sales within the date slicer selected by the end user of the report.

I have tried with calculated columns; however, it takes into account all the product purchases made by users instead of within the date range picked as I hoped it would.

My data (for 14th Feb as the date picked by the end-user) currently looks like this -

User ID	Product ID	Dates
user01	p1	14/02
user023	p2	14/02
user12	p3	14/02
user12	p4	14/02
user023	p3	14/02
user05	p1	14/02
user99	p2	14/02
user12	p3	14/02
user01	p2	14/02

The output I expect to see - How many users have purchased the product how many times?

2 users have purchased 2 products

1 has purchased 3 products

2 have purchased 1 product

Users	Products
2	2
1	3
2	1

Please feel free to ask for more information. Thank you!

Re: Find out how many users have purchased products

lbendlin — Fri, 16 Feb 2024 02:02:55 GMT

Unlike Tableau, Power BI does not support dynamic bucketing, You need to bring your own buckets.

see attached

topic Re: Find out how many users have purchased products in DAX Commands and Tips

Find out how many users have purchased products

Re: Find out how many users have purchased products