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.
My colleague and I are trying to create a table visual that combines aggregated data from two tables. Table 1 contains data on my company's clients and Table 2 contains a list of all potential clients. We want to generate a table visual that combines and shows the counts of current clients and potential clients by U.S. state (see below).
The Current Clients field is a measure that is calculated by:
I am able to generate the correct total count for clients (394) but my colleague is unable to produce the same results, even though we are working off the exact same data files and have copied each step side-by-side. We found that my colleague's table visual is leaving off (not counting) the final 6 rows of data for FL, resulting with 388 as the total, even though we have set up the exact same relationships, measure, and data tables. (Note that the 6 omitted FL records are not the very last rows on the table, but are the final 6 records just for the FL rows.)
Does anyone know why this discrepancy is occurring and how we resolve the issue so that he can reproduce my results?
Hi @kchi ,
I can’t reproduce your issue. Can you share more details ?
Maybe you could share us a sample file and mask the sensitive data. Then we can try to reproduce the issue and solve it.
Best Regards,
Xue Ding
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @kchi
Try to create a new PBIX file for you both.
And/Or provide us the PBIX files for reference.
It can be a buggy PBIX file, or a filter is applied somewhere on the way.
Cheers!
A
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 |
---|---|
117 | |
105 | |
69 | |
67 | |
43 |
User | Count |
---|---|
148 | |
103 | |
103 | |
88 | |
66 |