Forum Discussion
Using two FILTER command in one CALCULATE
Hello Community, Here is the DAX formula I have which is not working : Count Year-1 = CALCULATE(DISTINCTCOUNT('FACT_TABLE'[ID]),FILTER( 'FACT_TABLE',OR('FACT_TABLE'[Flag1] = 1,'FACT_TABLE'[Fl...
I finally managed to solve my issue, with a solution I wouldn't use, but... I'm struggling.
What I did is creating a new colum, with the result of OR(Flag1 = 1, Flag2 = 1).
Then I replaced this :
FILTER(
'FACT_TABLE',OR('FACT_TABLE'[Flag1] = 1,'FACT_TABLE'[Flag2] = 1))By this :
Flag3 = true
Avoiding the use of FILTER statement did the trick.
I finally managed to solve my issue, with a solution I wouldn't use, but... I'm struggling.
What I did is creating a new colum, with the result of OR(Flag1 = 1, Flag2 = 1).
Then I replaced this :
FILTER(
'FACT_TABLE',OR('FACT_TABLE'[Flag1] = 1,'FACT_TABLE'[Flag2] = 1))
By this :
Flag3 = true
Avoiding the use of FILTER statement did the trick.