Forum Discussion
Helper IVHow to make relation work like "left join" instead on "inner join"?
I am working on following data model.
Fact table has very few values for contract column where as Projects have alot more. If I use a Contract column from Projects table and any facts from fact table, only jobs that exist in fact table show up in visual. Rest all disappear. I come from strong SQL backgroup and in my mind this behavior is similar to "inner join". How to change this so that I see all the jobs from projects table and if facts are not available, they are replaced with 0.
I have modeled this relationship as many to one but that could be one to one as well.
You are close on the inner join idea but it is really just a "filter to only show me rows where my measure returns a value".
It's more like a HAVING SUM ( Value ) <> NULL
You can modify your meausre by adding +0 to the end or you can set your visual to show items with no data on the Contract.
1 Reply
- jdbuchanan71
Super User
You are close on the inner join idea but it is really just a "filter to only show me rows where my measure returns a value".
It's more like a HAVING SUM ( Value ) <> NULL
You can modify your meausre by adding +0 to the end or you can set your visual to show items with no data on the Contract.