Forum Discussion

Syndicate_Admin's avatar
Syndicate_Admin
Icon for Administrator rankAdministrator
2 years ago

Multiple tables with multiple columns of dates, blank data using USERELATIONSHIP

Good day everyone, I'm creating a performance report of the company's salespeople, and the source of the data is in the sales table and the tables of our CRM. I have a calendar table in the...
Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi Epinedo ,

It sounds like because the date column in the table with the relationship you are using as a slicer is causing your visual objects and MEASURES to be affected by multiple filters. In general, I would recommend that you add an additional date table that has no relationship to any of your current tables and then use that in DAX:

'Calendar'[Date] = SELECTEDVALUE('NewTable'[Date])

That's just one example I'll give you. The exact solution will have to be changed to suit your situation. Could you please provide a screenshot of the sample data and the relationship between the tables, it would be helpful!

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

Syndicate_Admin's avatar
Syndicate_Admin
Icon for Administrator rankAdministrator
2 years ago

Hi Dino,

Thank you for your reply, but I think this didn't help fix my problem. Here I share with you a screenshot of what the relationships between my tables look like, I point in yellow to the date columns that I am relating.