Forum Discussion
Solved
Combining AllSELECTED with ALLEXCEPT
Hello, Let's say I have a visual table like below and my problem regards to AvgNumber measure. To make it simple I'am going to split the problem into a few steps. First visual(table) below s...
Frajzerr , Try like
calculate(Average(Table[Number]), filter(allselected(Table), Table[Product] = max(Table[Product]) && Table[Type] = max(Table[Type])) )
amitchandak
Super User
Super UserFrajzerr , Try like
calculate(Average(Table[Number]), filter(allselected(Table), Table[Product] = max(Table[Product]) && Table[Type] = max(Table[Type])) )
Thank you !!
It is working great, would you be so kind to give a short explanation of what your DAX query actually did ?
I mean you propably used Filter to be able to use expressions in Calculate filter field right ? But I don't understand what field = max(field) is doing.
