Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!The Power BI Data Visualization World Championships is back! It's time to submit your entry. Live now!
Hi,
I have a caluclated measure (Average Score) which is a function of two other measures (TotalScore = Sum(Table[Score]) and SCount = Count(Table[Score]). To plot the average score in a circle, using a scatter diagram, I am trying to calculate the x and y using sin and cos, respectively, and radians based on categories, where the angle should be looked-up using related-table. In MS Excel this would have been straightforward, but in Power BI the result seems to be multiplied by the product of 'the number of attributes in a category' times 'the number of respondents'. What am I doing wrong here?
Hmm, can you supply some sample data and more information on your calculations? I have some Quick Measures submitted to the gallery for converting Catesian coordinates to Polar, (and the reverse) not sure if those would be of any assistance:
https://community.powerbi.com/t5/Quick-Measures-Gallery/Cartesian-2-Polar/m-p/347574
The Power BI Data Visualization World Championships is back! It's time to submit your entry.
Check out the January 2026 Power BI update to learn about new features.
| User | Count |
|---|---|
| 56 | |
| 42 | |
| 41 | |
| 21 | |
| 21 |
| User | Count |
|---|---|
| 150 | |
| 107 | |
| 64 | |
| 36 | |
| 36 |