Forum Discussion
Dates and relationships
Your measures are currently calculating the total number of assignments that has a specific startdate/enddate. If you place them both in cards without applying any filters, they will give you the exact same value as every assignment you have will include both start and enddate.
Community ChampionYour measures are currently calculating the total number of assignments that has a specific startdate/enddate. If you place them both in cards without applying any filters, they will give you the exact same value as every assignment you have will include both start and enddate.
Thanks tex628 , now I understood :)
Do you also know how I can count assignmentsid and filter on startdate is greater less than today and end date is greater than today?
- tex628
Do i understand you correctly that you want to count the total number of assignments that are currently active? (Started but not ended)
tex628 Yes :)
I was thinking this should work, but it gave me me 113, and it should have been over 200
candicates on assignments = CALCULATE(DISTINCTCOUNT(Assignments[CandidateId]); FILTER(Assignments; Assignments[StartDate]<TODAY()&& Assignments[EndDate]>TODAY()))
Or this one returns 113 as well:
candicates on assignments = CALCULATE(DISTINCTCOUNT(Assignments[CandidateId]);Assignments[StartDate] < TODAY(); Assignments[EndDate] > TODAY())
- tex628
Those measures look like they should work ...
Create a normal table, assignment , startdate & enddate then add the measure at the end. You should be able to tell which assignments are included as they should get a "1".
Find a row that should have a "1" but hasn't and we'll go from there and figure out what's wrong!
/ J