Forum Discussion
Solved
Sales per date filter not applied
Hellow CustomerID ContractID Start Location 822TR2020 CB1_6532020 30/10/2020 1 944TR2021 CB1_7962021 10/04/2021 1 49TR2020 CB1_5782020 1/03/2019 1 771...
- InHuizingenPerDatum = CALCULATE(COUNT('Bewoners_Contracten (Sharepoint)'[DatumInHuizing]),FILTER('Bewoners_Contracten (Sharepoint)','Bewoners_Contracten (Sharepoint)'[DatumInHuizing] >= FIRSTDATE(DateTable[Date])&&'Bewoners_Contracten (Sharepoint)'[DatumInHuizing] <= LASTDATE(DateTable[Date])))
InHuizingenPerDatum = CALCULATE(COUNT('Bewoners_Contracten (Sharepoint)'[DatumInHuizing]),FILTER('Bewoners_Contracten (Sharepoint)','Bewoners_Contracten (Sharepoint)'[DatumInHuizing] >= FIRSTDATE(DateTable[Date])&&'Bewoners_Contracten (Sharepoint)'[DatumInHuizing] <= LASTDATE(DateTable[Date])))