Forum Discussion
Helper IIMixed Model - Direct Query with Subset of Records to Imported Datasets
Hi dkernen2,
As pbix file is connecting to snowflake and can't see the sample data. But thanks for sharing the pbix file. Just for your security purpose, I would suggest always share sample data data only. Do not share the whole connection details and other major information.
I created a new page with solution steps in the below pbix file , please check it.If this reply helped solve your problem, please consider clicking "Accept as Solution" so others can benefit too. And if you found it useful, a quick "Kudos" is always appreciated, thanks!
Best Regards,
Maruthi
Helper IIGlorious! Thank you so very much. I am pasting the solution steps below for others' benefit.
1.Set Up the Relationship
- Create a single-direction relationship from Grant Applications[Request ID] → GRANTS CALIBRATION[Request ID]
- Ensure the relationship is not filtering in both directions to avoid duplication.
2.Create a Measure to Simulate Left Join
Here’s a DAX measure that ensures all 217 rows from Grant Applications are shown, even if there’s no match in the DirectQuery table:
3.Use Grant Applications as the Base Table in Visuals
- Use Grant Applications in your matrix or table visual.
- Add the Cal Status measure or similar to pull in values from the DirectQuery table.