Hi Community.
I search in this forum and in network also discussions about REMOVEFILTERS vs ALL.
Usage is not clear for me again...
I created a measure to calculate rolling (3,6,12 months depending by user choice ) but I got different result using REMOVEFILTERS and ALL+FILTER.
1st measure:
By my knowledge, I can use REMOVEFILTERS to delete specific filter in a table to apply new one and preserve any other filters:
(consider Country XX selected in the report)
....
CALCULATE ( sum(MyTable[#Volume] )
;REMOVEFILTERS( MyTable[ColumnDate] )
;and( MyTable[ColumnDate] >=VarFirstDate ;MyTable[ColumnDate] <=VarLastDate )
)
VarFirstDate,VarLastDate are calculated variables. Country filter continues to be applied.
2nd measure created due to incorrect result in previous. ALL function should remove all filters.
Considering same Country XX selected in the report.
I calc VarFirstDate,VarLastDate and new variable VarSelectedCountry:
....SUMX( filter( all(MyTable)
;and(MyTable[CountryColumn] = VarSelectedCountry
;and(MyTable[ColumnDate] >=VarFirstDate ;MyTable[ColumnDate] <=VarLastDate )
)
)
;MyTable[#Volume]
)
This measure returns correct values.
Problem is that I need to evaluate any filter I have in the page (a lot of) and I need to change the measures (a lot of...) if I add a new filter in the page.
My opinion is I should have same results (of course, if above measures don't have errors...).
Thanks,
Bye!
