Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

AVERAGE DAX function do not work as expected

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...
  • Anonymous's avatar
    Anonymous
    5 years ago

    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

amitchandak's avatar
amitchandak
Super User
5 years ago

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.

Anonymous's avatar
Anonymous
Not applicable
5 years ago

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