Forum Discussion

karyani's avatar
karyani
Frequent Visitor
1 year ago
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...
  • sjoerdvn's avatar
    sjoerdvn
    1 year ago

    try something like 

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

or even

calc = CALCULATE(DISTINCTCOUNT(FactTable[TransactionCode])
                ,All(Dimintion)
                ,FactTable[CancelXID] 
       )
sjoerdvn's avatar
sjoerdvn
Icon for Solution Sage rankSolution Sage
1 year ago

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())
       )

 

 

karyani's avatar
karyani
Frequent Visitor
1 year ago

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