Simple query join

[Anonymous]

Hi everyone. I am new to Power BI but quickly learning my way around. I am stuck at getting an aggregate count of a joined query(merge queries). I am left outer joining my calls query to my locations query by locationID. That appears to look great, but when I expand the field in my locations query and get a count of the location field, even locations that did not have any calls, now have a count of 1. When looking at the Call query, everything looks normal. What am I doing wrong with the merge? Thanks for any help.

[v-jiascu-msft]

Hi @Anonymous,

Can you share the file? Please mask the sensitive parts.

1. Seems you should do the last steps in DAX. Can you share the formula?

2. Where did you see the "a count of 1"? In a visual?

3. Maybe you reversed the order of the tables. But you see the merged table is good. Please refer to the snapshot below.

Best Regards,
Dale