Hello. I'm using power pivot and I have two fields. Customers and claims. I did a distinct count for both of them. Then there is a field that is the sum of an expense for all the items. I wanted to calculate this total divided by distinct customer count to get claims cost per customer. This doesn't work and returns an error. However, if I create a calculated field WITHIN the manage data window for each this items (unique count column and then sum values for claims column) and then create a calculated field based on these calculated field, then it works. Why is this?
Bookmarks