Forum Discussion
Continued ContributorHow to get Transaction count for each customer?
Hi Folks,
can you please guide me how to get Order ID count for each customers based on slicer or filter selection I have in report.
Example: I have country, Date, Product Type slicers. Based on these slicers selections i want to get Order ID count dynamically. When I try All or Allexcept function results are getting weird. Even with Order ID column in the layout, i want to get cout of Order ID for each customer.
PFA sample data.Thanks in advance.
i have used calculate(count( orders([order id]), all selected (orders [order date]))
Regards
BVK
Thanks everyone for your inputs. I am able to achieve this requirement using Segmentation and Grouping.
4 Replies
- amitchandak
Super User
itsmebvk , Try a measure like
calculate(count( orders([order id]), filter(allselected(orders), orders[Customer ID] = max(orders[Customer ID])))
itsmebvkThanks for quick reply. I tried using above expression. But when I use this expression in different calculations numbers are going off.
for example :
step1: i want to calculate number of orders for each customer based on given slicers
step2: Based on numbers of orders I want to bucket customers.
example: I want say There are 100 customers with 2 orders, theres are 50 customers 4 orders . Using this I am trying to populate my sale order.
above expression not working when I use it for bucketing numbers of customers based on that I want to show sales value for each bucketing.
- itsmebvk
Thanks everyone for your inputs. I am able to achieve this requirement using Segmentation and Grouping.
