Forum Discussion
Solved
Dax All not ignoring filter
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[Transactio...
try something like
calc = CALCULATE(DISTINCTCOUNT(FactTable[TransactionCode]) ,All(Dimintion) ,FactTable[CancelXID] <> BLANK() ) or even calc = CALCULATE(DISTINCTCOUNT(FactTable[TransactionCode]) ,All(Dimintion) ,FactTable[CancelXID] )
The fist option seems to work :), so why Filter does not work?
sjoerdvn
Solution Sage
Solution SageThe 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())
)
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