topic Re: DAX- Calculating Average in DAX Commands and Tips https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/DAX-Calculating-Average/m-p/3448515#M131289 <P>You don't need DAX or a matrix for that</P> <P>&nbsp;</P> <P><img /></P> <P>&nbsp;</P> <P>&nbsp;</P> <P>Maybe adjust your sample data a bit to make it more interesting?</P> Tue, 26 Sep 2023 19:38:06 GMT lbendlin 2023-09-26T19:38:06Z DAX- Calculating Average https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/DAX-Calculating-Average/m-p/3446601#M131152 <TABLE border="1"><TBODY><TR><TD>Club Name</TD><TD>Agreement Number</TD><TD>Profit Center</TD><TD>Payment Amount</TD></TR><TR><TD>Club Daisy</TD><TD>1231</TD><TD>Dues</TD><TD>15.99</TD></TR><TR><TD>Club Lily</TD><TD>8952</TD><TD>Annual</TD><TD>49.99</TD></TR><TR><TD>Club Marigold</TD><TD>4582</TD><TD>Processing Fee</TD><TD>1.99</TD></TR><TR><TD>Club Orchid</TD><TD>8962</TD><TD>Dues</TD><TD>15.99</TD></TR><TR><TD>Club Rose</TD><TD>4562</TD><TD>Annual</TD><TD>49.99</TD></TR><TR><TD>Club Daisy</TD><TD>7862</TD><TD>Processing Fee</TD><TD>1.99</TD></TR><TR><TD>Club Lily</TD><TD>3252</TD><TD>Dues</TD><TD>15.99</TD></TR><TR><TD>Club Marigold</TD><TD>4562</TD><TD>Dues</TD><TD>15.99</TD></TR><TR><TD>Club Orchid</TD><TD>8232</TD><TD>Annual</TD><TD>49.99</TD></TR><TR><TD>Club Rose</TD><TD>1232</TD><TD>Processing Fee</TD><TD>1.99</TD></TR><TR><TD>Club Daisy</TD><TD>8342</TD><TD>Dues</TD><TD>15.99</TD></TR><TR><TD>Club Lily</TD><TD>2312</TD><TD>Dues</TD><TD>15.99</TD></TR><TR><TD>Club Marigold</TD><TD>4252</TD><TD>Dues</TD><TD>15.99</TD></TR></TBODY></TABLE><P><FONT color="#FF0000">Here, I want to create a measure that calculates the Average Dues.&nbsp;</FONT><BR />For example: Here we have 7 Members that have Profit Center as Dues.&nbsp;<BR />Now, If I calculate Average Dues for Just Club Daisy. It would be Average Dues = Payment Amount (15.99 +15.99) /2 (There are 2 members in Club Daisy that has Dues). Now the Average Dues would be 31.98/2, which is $15.99. So, the Average Dues for Club Daisy is $15.99.&nbsp;<BR />In same way, I want to calculate Average dues for all the other clubs and create a matrix visualization that displays club names and their average dues.&nbsp;<BR />Thank you.&nbsp;</P> Mon, 25 Sep 2023 19:40:00 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/DAX-Calculating-Average/m-p/3446601#M131152 101 2023-09-25T19:40:00Z Re: DAX- Calculating Average https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/DAX-Calculating-Average/m-p/3448515#M131289 <P>You don't need DAX or a matrix for that</P> <P>&nbsp;</P> <P><img /></P> <P>&nbsp;</P> <P>&nbsp;</P> <P>Maybe adjust your sample data a bit to make it more interesting?</P> Tue, 26 Sep 2023 19:38:06 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/DAX-Calculating-Average/m-p/3448515#M131289 lbendlin 2023-09-26T19:38:06Z