topic Re: All Function in AverageX in DAX Commands and Tips

All Function in AverageX

Rastelka — Fri, 13 Jan 2023 10:15:52 GMT

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)

PriemerProdukt = AVERAGEX('Product', SUMX ( RELATEDTABLE(Sales), Sales[Quantity] * Sales[Net Price] ))

(Second Picture)
PriemerALL = AVERAGEX(ALL('Product'), SUMX ( RELATEDTABLE(Sales), Sales[Quantity] * Sales[Net Price] ))

Thanks a lot.

Re: All Function in AverageX

ValtteriN — Fri, 13 Jan 2023 10:21:55 GMT

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/

Re: All Function in AverageX

Rastelka — Fri, 13 Jan 2023 11:07:10 GMT

Hello,

I thought that ALL removes the Filter Context only when it's used with Calculate. Or is that incorrect? Thanks a lot!

Re: All Function in AverageX

FreemanZ — Fri, 13 Jan 2023 11:18:14 GMT

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.

Re: All Function in AverageX

Rastelka — Fri, 13 Jan 2023 11:28:21 GMT

Thanks a lot FreemanZ 🙂