topic Re: AVERAGE DAX function do not work as expected in DAX Commands and Tips

AVERAGE DAX function do not work as expected

Anonymous — Thu, 29 Oct 2020 15:20:28 GMT

Hi Experts,

I observed a weird thing about AVERAGE or SUM DAX function.
When I am creating a CARD and then inserting the field directly from the data model hierarchy and choosing SUM or AVERAGE, it works perfectly fine.

138 is correct average.

However when I simply calculate using DAX code

Can you kindly point out where am I going wrong with the DAX formula?

Thanks,
Rohit

Re: AVERAGE DAX function do not work as expected

amitchandak — Thu, 29 Oct 2020 16:34:54 GMT

Anonymous , this should happen without a filter.

Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.

Re: AVERAGE DAX function do not work as expected

Anonymous — Fri, 30 Oct 2020 06:12:00 GMT

amitchandak , won't be able to share the data due to confidentiality reasons.
However, I did copy the table contents in an excel sheet and connected it with a fresh new PBI file.
The AVERAGE measure and the AVERAGE by field mapping worked fine and are the same for the same filter conditions.

I will create a fresh file instead.
Closing this thread and marking it as "Solved"

Thanks,
Rohit