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,
My dashboard is built using Direct Query. The tables that are being referenced are at a granular level (eg. employee_id) , and the aggregation is done on the report using "Unique Count" i.e. count(distinct)
However, the counts displayed on dashboard don't match the count in the table that is being referenced
Any ideas? Known Bugs?
Thanks,
Sneha
HI, @snehajayakesh
The result need some time to “Refresh the cache”, please wait some time or you could refresh dataset manually.
Best Regards,
Lin
Hi Lin,
I believe caching won't be valid for Power BI Desktop.
Visuals where I am aggregating data on report are meant to display count(distinct), however, it simply 'counts'. Any help is highly appreciated.
Visuals used: Stacked Bar, Map, Card (no custom visual)
Thanks,
Sneha
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 |
---|---|
106 | |
94 | |
77 | |
65 | |
53 |
User | Count |
---|---|
145 | |
105 | |
104 | |
90 | |
63 |