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,
I have a problem with a pie chart. It should show the number of stores visited. As some stores are visited more often I set the value amount of PoiID (Point of interes ID) to "unique". However the percentage is wrong. The amount of "Merkur" ist 201 from 706 which is about 28% not 22%. When I visualize this in an matrix-chart the figures are correct.
I hope the numbers are not to small on my screenshots.
Not filters are activated.
Thanks in advance for your help.
Best regards,
Jack
can the same POID be recorded against different stores? when you do the distinct count on poid, you might have the same POID under different stores? It will count it uniquely under each store but if there is a POID under 2 stores, it will double count it because your aggregation is under the store but the total will look at the total unique POID.
Proud to be a Super User!
Thanks yes that was the problem. It was just too much data to see it instantly.
Actually every PointOfInteres-ID is unique. But there are some manually added Poi's which get assigned with the same ID.
Thanks!!
BG Jack
Hi @EdList ,
Are both visuals (table and pie chart) with the same filters and information?
To what I can check the count on the pie chart give around 898 counts and on the table you have the 706.
Try to convert the matrix to a pie chart and check if it still give you the same percentage.
Can you share a sample?
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsHi @MFelix,
your calculation is correct and yes it is exactly the same chart. I copied the chart and just changed it to the a matrix and also tried it in the other direction.
I tried deleting all charts and create new ones, .... nothing worked.
I just think it might miscalculate something because of the "unique IDs". Maybe it checks the unique values within the group "Merkur" than checks the unique values in the next group and so on and than sums everything up which might equals more unique values than they actually are because the same ID is unique in another group?
Is that possible?
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 |
---|---|
111 | |
100 | |
80 | |
64 | |
58 |
User | Count |
---|---|
148 | |
111 | |
93 | |
84 | |
66 |