Forum Discussion
Create pie chart with categories using a measure
Hi, I have data with customer ids where each row represents transaction info. I am supposed to find average transaction per day for each customer. There is a slicer for date where I can choose last ...
Hi! Thanks for your reply. My problem is that, lets say in your example, the table you created will give me same result each time as when I choose different dates in my date slicer (like last 30 days or last 40 days). It can not be placed as a table with fixed values you just showed. This is my measure which say avg transactions per customer.
avg per day = DIVIDE(COUNTROWS('existing table'), DATEDIFF(MIN('Calendar'[Date]),MAX('Calendar'[Date]), DAY)+1)
I have a slicer in my dashboard which chooses from Calendar'[Date] and change the values in dashboard for different customers. How can I end up with a pie chart that will categorize less than 2, more than 2, more than 5 etc with changed values each time depending on date slicer?