I've attached a workbook that I think meets your requirements. The way I interpreted them is that you want a sum of all the items sold, divided by the sum of the count of users per day. Since the count of users per day shows up on every record, we want to only count those users once. A way to do that is to bring the Date into the view on the Level of Detail Shelf, then use a table calculation to sum the count of users per day. However, since Date is now in the Level of Detail and would return multiple values per cell in the view, the other calculations in the view need to be modified to remove that.
You can filter the dates and/or the items and the calculations will appropriately adjust.
sum of average.twbx.zip 14.3 KB
Thanks for the quick response. It sounds like you understood my question correctly, but unfortunately, I am not able to open your workbook (it says it is missing an underlying Excel file).
I might be able to reproduce it myself, but I don't quite understand what the "Level of detail" shelf does, so I hope you can upload your worksheet again.