Forum Discussion
Post PartisanCustomer count not showing correctly
You can use the expanded table context to get the answer
count of customers =
Countrows(
Summarize( FactInternetSales, DimCustomer[customer key]
)
)
... or you can let the data model do that work for you
The crossfilter should of be on sales <-> customer rather than date. Filters travel in the directions of the arrow, in your model the relationship is customer -> sales, so the filter cannot travel to customer as the arrow is pointing the wrong way.
The simpliest thing was to do a distinctcount( sales[customerId] ) then you don't have to bother travelling from the sales table. Would only be worth it if you wanted to count a attribute that was in the customer table
Post PartisanJust for my understanding, any particular reason why the cross filter method shows repeating total against calender year? Is there anything wrong with this method?
- Deku
Super User
The crossfilter should of be on sales <-> customer rather than date. Filters travel in the directions of the arrow, in your model the relationship is customer -> sales, so the filter cannot travel to customer as the arrow is pointing the wrong way.
The simpliest thing was to do a distinctcount( sales[customerId] ) then you don't have to bother travelling from the sales table. Would only be worth it if you wanted to count a attribute that was in the customer table