Forum Discussion
Solved
Help with measure - count incidents between given dates
Hi I need some help with a measure please! I have two tables as below. Table 1 shows a list of contracts that can renew leading to multiple rows for the same contract but with start/end dates to ...
you just need to write a measure as follows:
measure incident_count := calculate (count(incidentdate) , filter (table 2 , incidentdate >= selectedvalue(contractstart) && incidentdate<= selectedvalue(contractend))
If this post helps, then I would appreciate a thumbs up 👍 and mark it as the solution to help the other members find it more quickly.
Selva-Salimi
Solution Sage
Solution Sage
you just need to write a measure as follows:
measure incident_count := calculate (count(incidentdate) , filter (table 2 , incidentdate >= selectedvalue(contractstart) && incidentdate<= selectedvalue(contractend))
If this post helps, then I would appreciate a thumbs up 👍 and mark it as the solution to help the other members find it more quickly.
Fantastic, thank you so much