topic Re: DAX for selecting team and average based on individuals in DAX Commands and Tips https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/DAX-for-selecting-team-and-average-based-on-individuals/m-p/2447380#M65738 <P>Hi&nbsp;<a href="javascript:void(0)" data-lia-user-mentions="" data-lia-user-uid="371211" data-lia-user-login="sjade" class="lia-mention lia-mention-user">sjade</a>&nbsp;</P><P>I assume that the result will be displayed in a card visual and the skill can be selected using a slicer. Then you may try</P><LI-CODE lang="javascript">Best Performing Teams = CONCATENATEX ( TOPN ( 1, ADDCOLUMNS ( SUMMARIZE ( Table, Table[Team] ), "@Average", CALCULATE ( AVERAGE ( Table[AreaRating] ) ) ), [@Average], DESC ), Table[Team], UNICHAR ( 10 ) )</LI-CODE><LI-CODE lang="javascript">Best Score = MAXX ( TOPN ( 1, ADDCOLUMNS ( SUMMARIZE ( Table, Table[Team] ), "@Average", CALCULATE ( AVERAGE ( Table[AreaRating] ) ) ), [@Average], DESC ), Table[Team] )</LI-CODE> Sat, 09 Apr 2022 19:16:33 GMT tamerj1 2022-04-09T19:16:33Z DAX for selecting team and average based on individuals https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/DAX-for-selecting-team-and-average-based-on-individuals/m-p/2446621#M65688 <P>I have a table with a similar setup as follows:&nbsp;</P><TABLE border="1"><TBODY><TR><TD><STRONG>Name</STRONG></TD><TD><STRONG>Team</STRONG></TD><TD><STRONG>Skill Area</STRONG></TD><TD><STRONG>Rating</STRONG></TD></TR><TR><TD>john</TD><TD>DE</TD><TD>SQL</TD><TD>3</TD></TR><TR><TD>john</TD><TD>DE</TD><TD>ETL</TD><TD>2</TD></TR><TR><TD>lauren</TD><TD>DE</TD><TD>ETL</TD><TD>3</TD></TR><TR><TD>sarah</TD><TD>DBA</TD><TD>SQL</TD><TD>2</TD></TR><TR><TD>sarah&nbsp;</TD><TD>DBA</TD><TD>SSRS</TD><TD>2</TD></TR><TR><TD>sarah</TD><TD>DBA</TD><TD>PowerBI</TD><TD>2</TD></TR><TR><TD>ben</TD><TD>BI</TD><TD>SQL</TD><TD>3</TD></TR><TR><TD>ben</TD><TD>BI</TD><TD>SSRS</TD><TD>2</TD></TR><TR><TD>george</TD><TD>BI</TD><TD>SQL</TD><TD>3</TD></TR><TR><TD>george</TD><TD>BI</TD><TD>SSRS</TD><TD>3</TD></TR></TBODY></TABLE><P>&nbsp;</P><P>I am trying to write a DAX measure to calculate which team has the highest average and also how to calculate that average -- thanks in advance!</P> Fri, 08 Apr 2022 17:38:57 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/DAX-for-selecting-team-and-average-based-on-individuals/m-p/2446621#M65688 sjade 2022-04-08T17:38:57Z Re: DAX for selecting team and average based on individuals https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/DAX-for-selecting-team-and-average-based-on-individuals/m-p/2447380#M65738 <P>Hi&nbsp;<a href="javascript:void(0)" data-lia-user-mentions="" data-lia-user-uid="371211" data-lia-user-login="sjade" class="lia-mention lia-mention-user">sjade</a>&nbsp;</P><P>I assume that the result will be displayed in a card visual and the skill can be selected using a slicer. Then you may try</P><LI-CODE lang="javascript">Best Performing Teams = CONCATENATEX ( TOPN ( 1, ADDCOLUMNS ( SUMMARIZE ( Table, Table[Team] ), "@Average", CALCULATE ( AVERAGE ( Table[AreaRating] ) ) ), [@Average], DESC ), Table[Team], UNICHAR ( 10 ) )</LI-CODE><LI-CODE lang="javascript">Best Score = MAXX ( TOPN ( 1, ADDCOLUMNS ( SUMMARIZE ( Table, Table[Team] ), "@Average", CALCULATE ( AVERAGE ( Table[AreaRating] ) ) ), [@Average], DESC ), Table[Team] )</LI-CODE> Sat, 09 Apr 2022 19:16:33 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/DAX-for-selecting-team-and-average-based-on-individuals/m-p/2447380#M65738 tamerj1 2022-04-09T19:16:33Z