FILTER vs Boolean Expression
I have two similar measures that in my mind should yield the same output, but in practice it gives me different results. While one uses the FILTER function, the other uses a boolean expression to filter. Can an expert help me understand why? First measure: DevOps - Completed Tasks - Filter = CALCULATE( DISTINCTCOUNT(factDevOpsTasks[Work Item Id]), FILTER( factDevOpsTasks, factDevOpsTasks[Work Item Type] = "Task"), USERELATIONSHIP(dimDate[Date], factDevOpsTasks[Completed Date])) First output: Second measure: DevOps - Completed Tasks = CALCULATE( DISTINCTCOUNT(factDevOpsTasks[Work Item Id]), factDevOpsTasks[Work Item Type] = "Task", USERELATIONSHIP(dimDate[Date], factDevOpsTasks[Completed Date])) Second Output: Thanks!
