Forum Discussion

SvenJacobs's avatar
SvenJacobs
Frequent Visitor
5 years ago
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...
Need Help
  • SvenJacobs's avatar
    SvenJacobs
    5 years ago
    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])))
AlB's avatar
AlB
Community Champion
5 years ago

HiSvenJacobs 

Not clear what you are trying to do. You can do a count of what? What is InHuizingenPerDatum, a measure? What is its code?  What else do you have in the model that is relevant?

Best if you can share the pbix

 

 Please accept the solution 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.

 

 

SvenJacobs's avatar
SvenJacobs
Frequent Visitor
5 years ago

Inhuizing per datum is a measure, bewoners contracten is the table above (start) is the amount of that i need.

InHuizingenPerDatum = COUNT('Bewoners_Contracten (Sharepoint)'[DatumInHuizing])
With no selection from the slider of location it is correct  
 

 

But when i want to see only the periode of 2017-2019 the data does not change in Datuminhuizingen

For Bree that should be 0 because the site just opened recently