Forum Discussion
Filtering two unrelated tables
Hi All, I need to calculate the total number of business days that company cars were in the garage being serviced (for a given month). To do this I need to: 1. filter the cars by the relevant ve...
AllisonKennedy
Community Champion
Community ChampionAnonymous Can you provide a screenshot of your relationships data model view and a few rows of sample data pasted directly into the post as well as mock up of final result?
Also, please paste your DAX directly into post rather than, or in addition to, screenshot so we can copy and modify it more easily.
You are doing
SUMX('Vehicles - Off-road', ...
but if I understand your question correctly I think you want to do
SUMX('Calendar (Dates)', ...
Filtering by the relevant vehicle type should happen automatically with the relationships, so if the tables are unrelated as you stated in the subject of this post, please explain why and how we find the 'relevant vehicle type' from the desired end result you want. Hope that makes sense?
Cheers!