Forum Discussion

conjaean's avatar
conjaean
Regular Visitor
3 years ago

Calculated table ignoring applied filters

Hi all,   I'm facing an issue with the creation of a calculated table. I have two tables: a DimDate table and a table "DimWerknemer" containing employees including the dates they started and left t...
NanDeb's avatar
NanDeb
Icon for Helper I rankHelper I
3 years ago

AMMENDED as I meant FILTER NOT SUMMARIZE  

 

ActiveUsers = 

VAR MinDate = 
CALCULATE(MIN('DimDate'[Dag]),KEEPFILTERS(DimDate))

VAR MaxDate = 
CALCULATE(MAX('DimDate'[Dag]),KEEPFILTERS(DimDate))
 
RETURN
FILTER('DimWerknemer','DimWerknemer'[InDienstVanaf]<=MaxDate,'DimWerknemer'[InDienstTot]>=MinDate)