Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi All,
I'm writing a DAX Query which exectutes different parts of the query depending on the current filter. This logic works, however:
In example #1, de removefilters works just fine. I'm getting values over a range of dates.
In example #2, the removefilters does not work. The result is a value on a single date.
It seems to be caused by the filter statement which i marked with as #3. Does anyone know if performing a removefilter together with another filter in the Calculate statement does't work? I can imagine the fact table inside #3 is still filtered by the date table. But how to get rid of the Date filter there?
I've tried to work with ALLEXCEPT(FACT,COLUMN,ETC). But so far no result.
Any help is appreciated.
Solved! Go to Solution.
@RemyBosman try to add another CALCULATE out of your code and move REMOVEFILTERS outside, such as
IsLevelDfiltered=CALCULATE(CALCULATE(SUM,FILTER,DATEBETWEEN),REMOVEFILTER)
Thanks Daniel! Works like a charm! 🙂
@RemyBosman try to add another CALCULATE out of your code and move REMOVEFILTERS outside, such as
IsLevelDfiltered=CALCULATE(CALCULATE(SUM,FILTER,DATEBETWEEN),REMOVEFILTER)
This works, but why? I would think it would remove the filter in the inner Calculate also, but it doesn't.
Hi @RemyBosman
By using the whole table 'Transformatie Dim_HoldingDate' as base for the FILTER( ) in #3, you are basically "bringing back in" whatever filter context is active on that table. If you are only filtering on the [NODE_NO] column, you can better use:
FILTER( ALL('Transformatie Dim_HoldingDate'[NODE_NO]), 'Transformatie Dim_HoldingDate'[[NODE_NO] = RELATED(.....))
Please mark the question solved when done and consider giving a thumbs up if posts are helpful.
Contact me privately for support with any larger-scale BI needs, tutoring, etc.
Cheers
Hi AlB,
I'm not using the holdingdate in the Filter in #3, did you accidently read it wrong, or do I misunderstand you?
User | Count |
---|---|
40 | |
26 | |
22 | |
16 | |
15 |
User | Count |
---|---|
54 | |
35 | |
18 | |
17 | |
15 |