Similar Values Rows

[puneet3114]

Hello everyone, I am working on 1 project and I am getting similar values again and again, I have tried other functions but it's still the same issue - 

I want total customers and using distinct count for that but when I try in matrix it gives same value.

Relationship

Fact table- 

[puneet3114]

Hi @TheoC I tried your solution and still facing the same issue, I will send you the PBIX file on LinkedIn if that's ok with you.

[TheoC]

Hi @puneet3114 

The reason that you are getting 9,164 in every single year is because you have 9,164 distinct Customer IDs in your dataset.  Your Year column is in the same table as your TimeKey table and there are TimeKeys allocated to each of your 9,164 Customer Ids in every single year.  

The output of 9,164 Customer Ids for every single year is correct in that regard.  The two tables below show yoru original table and on the right show the second table I put together.  

If some of your Customer Ids did not have a TimeKey in a specific Year, then the 9,164 would be different. But each one is allocated a TimeKey in the Time Details table and, as such, they appear accordingly.

Hope that makes sense.

Theo

[TheoC]

It's more than okay @puneet3114!  I look forward to receiving it and helping resolve it.

[TheoC]

Hi @puneet3114 

Without having direct access to your PBIX file, it's hard to guarantee a solution. But can you please try the following:

1. The relationship from Customer Details to Fact table might be best as single direction.
2. Create a new measure [Total Customers] that is based on the Customer Details table.  
3. Drag the new [Total Customers] measure into the Matrix visual.

Hopefully the above helps.

Theo