Forum Discussion
mp390988
Post Partisan
Post PartisanCustomer count not showing correctly
This is my model. I am trying to show a visual that shows the customer count per year so I created a measure called count of customers which is defined as belows. The reason why I am using ...
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
