Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Jannis68
Frequent Visitor

Calculating measure with RELATED at get wrong answer

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?

1 REPLY 1
Greg_Deckler
Super User
Super User

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

 


@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
Mastering Power BI 2nd Edition

DAX is easy, CALCULATE makes DAX hard...

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.