Calculating the percentage that a measure is greater than 5

[Benchmura]

Hi, I am trying to calculate what percentage of my total approved items fall over a 5 day threshold in age. 

The "Age" column below is a DATEDIF measure that shows the date difference between when an item was approved and todays date.

I would like a card that shows what percentage of the "Age" measure column falls above 5 days.

Formulas I have tried will not allow me to find the column due to it being a measure rather than a field.

Any help would be greatly appreciated!

Ben 

[Padycosmos]

Hope this helps:

[Benchmura]

Hi @Padycosmos 

Can you see where I might be going wrong?

True result should be around 70 results > 4.

Mine's returning 279!

Thanks,

Ben 

[Padycosmos]

Your measure apparently looks OK. If the data is not sensitive, could you please share the PBIX file?

[Benchmura]

Unfortunately although the page is fine, the dataset is sensitive i'm afraid 

[Padycosmos]

[Benchmura]

It's only age on the visual, true measure name and table location is as below:

[Padycosmos]

You may, try this 

Age > 5 =

VAR summary = SUMMARIZE('Table','Table'[Date1],"Diff",[Age])

RETURN

COUNTX(FILTER(summary,[Diff]>5),[DIFF])

[Padycosmos]

Could you please share the formula used in that measure?

[Benchmura]

Hi Pady, apologies for the delay - I got there in the end with a Distict count.  

What I now need to do is work out the Count > 4 days as a percentage of all approved items:

Would you know what's needed please?

Thanks again for all your help 

[Padycosmos · Accepted solution]

You may create another measure for finding the count of 'Approved' as follows:

Count Approved = Calculate(Count(PurchaseRequisitionLines[Purchase Requision No_]),FILTER(PurchaseRequisitionLines,[Staus]="Approved")

Then, to find the percentage use the following

pct = DIVIDE(TIMO Sum od Count>4, Count Approved)

[Benchmura]

Worked Perfectly, thank you!