CountIf Calculations

[DieLem]

Hi All,

I have a fundamental issue that I am sure is very simple but I can't seem to find a solution.

Here is a sample table with data:

OrderID	Delay (Days)
1	3
2	5
3	8
4	9
5	2
6	5

I want to determine how many orders have a delay bigger that 7, devided by the total number of orders. Thus it should be:

[2 (The count of 8 and 9)]/[6 (Count of total entries)] = 33%.

Thanks for the help!

[Zubair_Muhammad · Accepted solution]

Hi @DieLem

Try this MEASRE

MEasure =
COUNTROWS ( FILTER ( TableName, TableName[Delay (Days)] > 7 ) )
    / COUNTROWS ( TableName )

[DieLem]

@Zubair_Muhammad

This is perfect. Thanks so much.