Forum Discussion
blank values with relationship
- Anonymous That solution will work, only potential issue is that Joins (or merge in Power Query language) can drastically slow down the refresh time of your query when compared to using the relationships. This usually isn't a problem though, especially if you can set an automatic refresh to load overnight.
Great troubleshooting and glad I could inspire a solution for you! Please mark this post as solved so others can easily find the answer.
Cheers!
Allison
Hello Allison,
Many Many thanks for your detailed replay, I walked through your reply step by step for the 2 first solutions and yes they are doable if I'm using those 3 tables only, I'm using more than 7 tables in my data model for this report, however, I got an idea from your solution and it seems to be fine now.
I've joined the "call" table with "line" table using left join on "call.number=line.number" then I joined the site table on the new "Calls" merged query on "line.site_id=site.site_ID" which created null rows on the calls table, then I've replaced the null values with "Not available" and counting calls based on the call.number column group by new merged column "site.site_name"
for example
| Call.Call number | Line.line number | Site.site_id | Site.sitename |
| 123 | 123 | ABC | Site 1 |
| 234 | null | null | null |
| 456 | 456 | DEF | site 2 |
| 345 | null | null | null |
456 456 DEF site 2
then I replaced the null values from line and site table to be "Not available" and that worked!
please if you see anything issues in my solution keep me updated.
Thanks
Re: Replace blank with Not assigned - Microsoft Fabric Community
I have the same problem. Kindly help.