Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
113 | |
99 | |
80 | |
70 | |
60 |
User | Count |
---|---|
149 | |
114 | |
107 | |
89 | |
67 |