Forum Discussion
Daily Changing Measure
Hey everyone! I'm struggling with this problem it's been a while and I didn't get to any results. I also din't find any similar problem with a sollution, so I decide to ask for help here. I h...
What is the code for your [Today's Open Jobs] measure and what does the data te measure uses look like? We need more info to come up with a solution
Please mark the question solved when done and consider giving kudos if posts are helpful.
Contact me privately for support with any larger-scale BI needs, tutoring, etc.
Cheers
My table collumns are basicaly: 'Job Id'; 'Job Title'; 'Responsible'; 'Request Date'; 'Delivery Date'; 'Status'; 'Comments'.
To get the [Today's Open Jobs] I'm using:
Today's Open Items =
CALCULATE(
COUNTA('Jobs 2020'[Responsible]);
'Jobs 2020'[Status]
IN {
"Closed: Cancelled";
"Closed: Finished"
}
)