Forum Discussion

Rastelka's avatar
Rastelka
New Member
3 years ago
Solved

All Function in AverageX

Hello everyone,   I am new to DAX and would appreciate a bit of help. Why these two meassures produce two different results in Power BI report? Thanks a lot for any answer.    (First Picture) ...
  • ValtteriN's avatar
    ValtteriN
    3 years ago

    Hi,

    ALL removes the filter context in your calculation and because of that the row level filter context that is available in your table is removed and all rows return the same result.

    I hope this post helps to solve your issue and if it does consider accepting it as a solution and giving the post a thumbs up!

    My LinkedIn: https://www.linkedin.com/in/n%C3%A4ttiahov-00001/

  • FreemanZ's avatar
    FreemanZ
    3 years ago

    hi Rastelka 

    ALL removes the filter context in any calculattion, like AVERAGX, not only in CALCULATE function. 

    In your first measure, Product table is filtered by the row filter of the table visual.

ValtteriN's avatar
ValtteriN
Icon for Community Champion rankCommunity Champion
3 years ago

Hi,

ALL removes the filter context in your calculation and because of that the row level filter context that is available in your table is removed and all rows return the same result.

I hope this post helps to solve your issue and if it does consider accepting it as a solution and giving the post a thumbs up!

My LinkedIn: https://www.linkedin.com/in/n%C3%A4ttiahov-00001/