Help Needed Please - KPI indicator At Aggregate Level for each Category

Hi There,

Please can someone help with any visuals guide or sample pbix for me here?

We have 'Program' and under every program, a few Tasks (1 to many). Not always all tasks Or All Programs will execute.

We track durations of each Tasks, (which can be used to add and get duration of different Program) and we also have Threshold (At Program Level).

Users are looking for Power BI chart/Report to See on a given date whether a Program executed, and if yes then whether

• Is it within Or Equal Thresold limit (then Green) else Red.
• Is it within Or Equal to the Average of Last 3 Execution duration of the Program (then Green) else Red. To note, this [Last 3 days] is indepent of any filter selection, rather it's purely based on entire dataset and last 3 run of a program is to be considered.

Here is my data sample

So we have 3 Tables.. 1 for Mapping between, Program and Task. Another for Program to Threshold Mapping; and finally, Log table for Task to Actual Duration per day.

From Here we can actually try to fist calculate 3days average for PLAN1 & 2, which will be like below,

And finally users need something as below (A date Slicer and a chart)....

Example, shows different value selections in date slicer

Thanks Much...