Forum Discussion

Frequent Visitor

2 years ago

Solved

REMOVEFILTERS Confusing Behavior

Hello, I came upon a case which got me super confused about the way DAX works. I'd appreciate it if you guys could take a look. Here is my model, there are 3 tables date, dim and fact as below ...

General Comment

amitchandak
2 years ago
mertolocel , Use it in countx like this

CALCULATE(COUNTx(FILTER(Employee,Employee[Start Date]<=max('Table'[Date]) && (ISBLANK(Employee[End Date]) || Employee[End Date]>max('Table'[Date]))),(Employee[Employee Id ])),CROSSFILTER(Employee[Start Date],'Table'[Date],None))

Super User

2 years ago

mertolocel , Use it in countx like this

CALCULATE(COUNTx(FILTER(Employee,Employee[Start Date]<=max('Table'[Date]) && (ISBLANK(Employee[End Date]) || Employee[End Date]>max('Table'[Date]))),(Employee[Employee Id ])),CROSSFILTER(Employee[Start Date],'Table'[Date],None))