Can list but can't count?

[rziya]

Hello, 

I am trying to count unique customers based on recorded workhours.. Apparently I can list them but not count...

In the left table I have month, customer Number and sum of workhours listed correctly. However when I change the CustomerNumber to show the Count or Count Distinct, Power BI seems to lose the count...

What could be causing that? If the relationships were a problem i would expect the list to be broken as well... I will try to replicate this in a simpler model as my current model is more complex than two tables. But the visuals below make me think there is something wrong that is beyond my reach...

[v-yanjiang-msft]

Hi @rziya ,

Do you need further help? If not, would you mind accept the helpful replies as solutions? Then we are able to close the thread. More people who have the same requirment will find the solution quickly and benefit here, thank you!

Best Regards,
Community Support Team _ kalyj

[rziya · Accepted solution]

Thank you everyone who replied, read and tought about it. It turned out to be a simple case of the relationship filter direction marked as single instead of both...  

[v-yanjiang-msft]

Hi @rziya ,

Because for the same Year Month, only unsummarized data can be listed, if you select count/sum, it turns to a summarized data and will sum up automatically. 

If you want to count the number of each customer in each YearMonth, you should put CustomerNumber in the visual twice, and only select Count in one of it. Like below:

Best Regards,
Community Support Team _ kalyj

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[rziya]

Thanks for the reply.

I am not sure I understand. I am trying to count the number of distinct customers in a month. Below is the table if I add both the customer and count/count(distinct).  I would expect the 142 to be 20 in both tables...

[Anonymous]

Did you used only visual filtering? What about use dax count?

Share the sample of file