Matrix display same values across all years

[PBI5851]

In the dashboard, among other tables, there is a referral Table and a Data table which have an inactive join on Referral.Referraldate (many :1) Datetable.Date.  I cannot make it active due to the way other tables are joined and making this active would create a many to many join with other tables. 

Multiple measures (that are shown as rows in screenshot) have been developed using the Userelationship function for both the above tables. When i plot the matrix, if i dont add the year, i get the correct data. But when i add the Year from the Datetable as i wish to have a hierarchy, i get the same value across all columns. 

What am i missing ? If i add the Referral.Referral date as the Column, i get the correct breakdown, but its not feasible to use it as the data is spread across multiple days. 

[amitchandak]

@PBI5851 , Date to fact table should be active as it one to many. Other bi-directional joins or many to many join causing the issue.  That needs to be addressed.

The current problem is because there no join(or use relationship is not used) between the date table and fact table.

https://www.sqlbi.com/blog/marco/2017/10/02/why-data-modeling-is-important-in-powerbi/

https://www.sqlbi.com/articles/the-importance-of-star-schemas-in-power-bi/

https://radacad.com/userelationship-or-role-playing-dimension-dealing-with-inactive-relationships-in...

[Fowmy]

@PBI5851 

Can you share one of the measures that are in the matrix? Also, a screenshot of the model relationships.
If you could share a sample PBIX will that would make it faster.

________________________

Did I answer your question? Mark this post as a solution, this will help others!.

Click on the Thumbs-Up icon on the right if you like this reply 🙂

YouTube, LinkedIn

[PBI5851 · Accepted solution]

The issue is resolved. It was a silly mistake on my part. I had the incorrect formula link in my query..  Thank you though.