help with avarage per etappe per office

Question

hello i need some help with a average formula&nbsp;i have a data sheet that looks like this:&nbsp;ETAPPE&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;OFFICE&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Naam&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Punten1&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Zwolle&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Roy&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 301&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Deventer&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Wouter&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 251&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Zwolle&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Roy&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 261&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Zwolle&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Petro&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;281&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Deventer&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Wouter&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 241&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Deventer&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Ivo&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;20ETC&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; ETC&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;ETC&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; ETC&nbsp;So i need a average per Office of the punten that i can use a slicer with the etappes i placed a screenshot of dashboard that you can see how i want to use it.so in the tabel that has a red line i want the punten to be a avarage of the total points from&nbsp; that office so if zwolle has 2 people and score 90 points in etappe 1 the avarage must be 45 points in etappe 1 etc etc&nbsp;

anonymous · Answer

Hi&nbsp;Anonymous&nbsp;,
Please try to create a measure with below dax formual:
Avg Per Eta and Office =
CALCULATE (
    AVERAGEX ( 'Table', [Punten] ),
    ALLEXCEPT ( 'Table', 'Table'[ETAPPE], 'Table'[OFFICE] )
)

Please refer the attached .pbix file.
&nbsp;
Best regards,Community Support Team_Binbin YuIf this post&nbsp;helps, then please consider&nbsp;Accept it as the solution&nbsp;to help the other members find it more quickly.

anonymous · Answer

a office can have&nbsp; multiple people i my test data every office has 1 person but in the real data every office has multiple people i have used your solution but it doesnt work for me i need&nbsp; the total points of a etappen divided by people that work on that office so for example the are working 5 people&nbsp;@ zwolle and those 5 score 20ppoints each there score is 100 for that etappe and those 100 points must be divede by those 5 people&nbsp;

anonymous · Answer

Hi&nbsp;Anonymous&nbsp;,
I'm a little confused about your needs, Could you please explain them further? It would be good to provide a screenshot of the results you are expecting and desensitized example data.
Thanks for your efforts &amp; time in advance.
&nbsp;
Best regards,Community Support Team_Binbin Yu

anonymous · Answer

its about the tour de france it has 21 etappes and we are doing a poule about it every person choose 20 players to form a team and on their team they score points on where they finishedfor example&nbsp;&nbsp;etappe&nbsp; &nbsp; &nbsp; &nbsp; office&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;person&nbsp; &nbsp; &nbsp; &nbsp;team&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; points1&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; zwolle&nbsp; &nbsp; &nbsp; &nbsp;roy&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; renner 1&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;201&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Zwolle&nbsp; &nbsp; &nbsp; &nbsp;roy&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;renner 2&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;151&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Zwolle&nbsp; &nbsp; &nbsp; &nbsp; roy&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;renner 3&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;101&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Zwolle&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Petro&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;renner 1&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 151&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Zwolle&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;petro&nbsp; &nbsp; &nbsp; &nbsp; renner 2&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 20etc&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;etc&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;etc&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; etc&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; etc&nbsp;so i have multiple people on 1 office but i also have multiple office and 21 etappes where people can make points so i need a total points of the office per etappe and then divided by the persons on that office so i can have a table with a rankx formula based on theri avarage score&nbsp;&nbsp;

Forum Discussion

help with avarage per etappe per office

4 Replies

Related content

avarage

Avarage Calculating

Path to onedrive folder office 365 home

Office 365 Email fails with connection error

Does Office 365 premium include Power BI Pro license?