Forum Discussion

miguesnet's avatar
miguesnet
Frequent Visitor
2 years ago
Solved

NB IF

Hi,    I am trying to calculate the nb of weeks we are above a saturation rate of 90% ,   Ex :  Week Workload Capacity 1 100 100 2 90 100 3 92 100 4 80 100 5 81 100...
Need Help
  • vicky_'s avatar
    vicky_
    2 years ago

    Try the below formula:

    saturation above 90 = 
var summaryTable = ADDCOLUMNS('Table', "saturation", DIVIDE('Table'[Workload], 'Table'[Capacity]))
RETURN COUNTROWS(FILTER(summaryTable, [saturation] > 0.9))
miguesnet's avatar
miguesnet
Frequent Visitor
2 years ago

Thanks a lot for your helps vicky_