Calculate a daily proportion over all days in filtered month

[d474boy]

I have a table of Jobs received on all days over several years.

Each Job has a target completion time and I can calculate if the completion time has been met.

I want to calculate the proprtion of all Jobs on each day that were completed on time.

Then I want the total number of days in a month where the proportion is >= 95%.

I have a report sheet that has a filter for the month in which Jobs were receieved, so I am only looking at 28-31 days of Jobs at a time.

I have a bar/line chart that shows the number of Jobs received each day and the proportion that were completed on time.

I can create a measure that calculates, for each day, if the proportion was over 95% or not (see formula below):

_ProportionOnTimeGe95pc = if([_ProportionCompletedOnTime]>=0.95,1,0)

That's easy.

But I then just want a Card visual that shows the Total of the 0s and 1s over all the days.

I thought that it just needed to create another measure that was:

SUM([_ProportionOnTimeGe95pc])

but this doesn't work.

Please help.

[d474boy]

My PBIX model 

Do I need to 'share' this file through OneDrive for you to be able to open it? @wzkoral @V-lianl-msft 

[V-lianl-msft]

Hi @d474boy ,

Measure is calculated based on the current context. Your expression is incorrect and does not use the correct filter function.

You can try the countrows function.

If the problem persists,could you please share sample data or sample pbix?(Please mask any sensitive data before uploading)

Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[d474boy]

Hi Liang

I have created a cut-down PBIX data model with all my queries and attempt to work around the problem. I will upload it now.

Thanks for helping

[wzkoral]

Share some sample data pbix or show some screenshots, with model relation,
What u see when u create a simple table with this measure _ProportionOnTimeGe95pc = if([_ProportionCompletedOnTime]>=0.95,1,0)

[d474boy]

Hi

I am going to upload a PBIX now (once I can work out how to).