topic Re: Dax All not ignoring filter in DAX Commands and Tips

Dax All not ignoring filter

karyani — Wed, 19 Feb 2025 14:13:49 GMT

the model has only 2 table FactTable and dimintions

the measure bellow works as expected, the calculation ignores the dimintion, (in a slicer)

calc = CALCULATE(DISTINCTCOUNT(FactTable[TransactionCode])

,All(Dimintion)))

if I add a filter on the FactTable it stops ignoring the Diminsion!

calc = CALCULATE(DISTINCTCOUNT(FactTable[TransactionCode])

,All(Dimintion)

,FILTER(FactTable,FactTable[CancelXID] <> BLANK())

)

after adding the above filter on the FactTable the All(Dimintion) stops working. when selecting differnt values from the slicer the calculation changes. what am I missing here, and how do I write the measure to ignore the Diminsion and still apply the ,FILTER(FactTable,FactTable[CancelXID] <> BLANK()?

thank you

Re: Dax All not ignoring filter

sjoerdvn — Wed, 19 Feb 2025 14:52:14 GMT

try something like

calc = CALCULATE(DISTINCTCOUNT(FactTable[TransactionCode]) ,All(Dimintion) ,FactTable[CancelXID] <> BLANK() ) or even calc = CALCULATE(DISTINCTCOUNT(FactTable[TransactionCode]) ,All(Dimintion) ,FactTable[CancelXID] )

Re: Dax All not ignoring filter

karyani — Wed, 19 Feb 2025 15:13:46 GMT

The fist option seems to work :), so why Filter does not work?

Re: Dax All not ignoring filter

sjoerdvn — Wed, 19 Feb 2025 15:26:34 GMT

The FILTER expression is evaluated in the "default" context so it includes any filter on "Dimintion" (sic). If you really want to use FILTER (don't know why people are using filter all the time...) you could use something like:

calc = CALCULATE(DISTINCTCOUNT(FactTable[TransactionCode]) ,All(Dimintion) ,FILTER(CALCULATETABLE(FactTable,All(Dimintion)),FactTable[CancelXID] <> BLANK()) )

Re: Dax All not ignoring filter

karyani — Wed, 19 Feb 2025 16:35:14 GMT

I don't "realy want to use Filter" I am trying to understand why it did not work, and what I am not understanding well when using it