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:   OrderID Delay (Days) 1 3 2 5 3 8 ...
  • Zubair_Muhammad's avatar
    8 years ago

    Hi DieLem

     

    Try this MEASRE

     

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