NB IF

[miguesnet]

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
6	95	100
7	100	100
8	75	100
9	85	100
10	98	100

Measure :  Saturation rate = Workload / Capacity

Expected result : 4

Thanks in advance for your help

Mickael

[miguesnet]

Thanks a lot for your helps vicky_

[vicky_ · Accepted solution]

Try the below formula:

saturation above 90 = 
var summaryTable = ADDCOLUMNS('Table', "saturation", DIVIDE('Table'[Workload], 'Table'[Capacity]))
RETURN COUNTROWS(FILTER(summaryTable, [saturation] > 0.9))