Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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
User | Count |
---|---|
141 | |
113 | |
104 | |
78 | |
64 |
User | Count |
---|---|
136 | |
125 | |
107 | |
70 | |
61 |