Forum Discussion

DieLem's avatar
DieLem
Helper II
8 years ago
Solved

CountIf Calculations

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:

 

OrderIDDelay (Days)
13
25
38
49
52
65

 

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!

 

 

Need Help
  • Zubair_Muhammad's avatar
    Zubair_Muhammad
    8 years ago

    Hi DieLem

     

    Try this MEASRE

     

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

2 Replies