Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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.
Solved! Go to Solution.
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.
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.
User | Count |
---|---|
141 | |
113 | |
104 | |
77 | |
64 |
User | Count |
---|---|
135 | |
123 | |
101 | |
71 | |
61 |