topic Re: Calculating Average by multiple columns in DAX Commands and Tips

Calculating Average by multiple columns

skolathu — Fri, 12 Aug 2022 07:38:01 GMT

Hi All,

I am trying to calculate average based on multiple column. Would have used AverageIfs in excel for this calculation.

Example:

Average Revenue by "FY Quarter, Month, City and product" and then calculate "Max Sales by FY quarter, Month and city" and finally calculate difference between "Max Sales by FY quarter, Month and city" and "FY Quarter, Month, City and product" in percentage. Based on high percentage of revenue need to get "Product" name as recomendation to taget.

Can any one help on how to do this in powerbi.

Regards

Sriram

Re: Calculating Average by multiple columns

amitchandak — Fri, 12 Aug 2022 09:40:05 GMT

skolathu , Assume you sum values and then table Avg, then you can try measure like. Same is true for Max /min etc

AverageX(summarize(Table, Table[Month Year], Table[product], "_sum", calculate(Sum(Table[Value])) ) , [_sum])

Re: Calculating Average by multiple columns

v-xiaotang — Wed, 17 Aug 2022 08:11:02 GMT

Hi skolathu

Thanks for reaching out to us.

How to convert AVERAGEIFS to dax code, please refer to this post https://community.powerbi.com/t5/DAX-Commands-and-Tips/AVERAGEIFS-in-dax/td-p/2653698

Best Regards,

Community Support Team _Tang

If this post helps, please consider Accept it as the solution to help the other members find it more quickly.