topic Re: Calculate average with filter in DAX Commands and Tips

Calculate average with filter

Anonymous — Thu, 28 Jul 2022 15:30:57 GMT

Hello everybody, i need to calculate an average

but i have to calculate the averagex with the despatch's quantity, for example, in brasil "Suma total de las etapas" = 157, and i have 21 despatch of this, i have to do 157/21 with each market. in case of chile will be 75/5.

Thanks

Re: Calculate average with filter

tamerj1 — Thu, 28 Jul 2022 15:48:06 GMT

Hi Anonymous

I don't think AVERAGE function ignores blank rows. However if it does you can divide the SUM over the COUNTROWS of the table

Re: Calculate average with filter

v-easonf-msft — Mon, 08 Aug 2022 09:44:38 GMT

Hi， Anonymous

If your problem has been solved, please accept the reply as solution to close this thread, so that other community members will easily find the solution when they get the same issue.

Best Regards,
Community Support Team _ Eason