Count how often condition is true on a day

[funtra513]

Hello, probably a pretty easy question, but I just can't figure it out for now. I have two tables. One containing production data, e.g. the order number, requirement date and production date. The other one being the date table. In order to create a burndown chart I would like to create a measure telling me how often the the requirement date is smaller than the production date for each specific day. Thank you in advance!

[tamerj1]

Hi @funtra513 

First make sure you have realationship created between date and Production Date comlumn. Then use this measure

Measure =
COUNTROWS (
    FILTER (
        Production,
        Production[Production date] > Production[Requirement date]
    )
)

of course it really depends on what exactly you need to achieve and how your data looks like. Hope this will help. Have a great day