CountIf Table

Sea_and_Anne — Tue, 10 Jan 2017 16:04:02 GMT

Hello,
I have a project manager table with the kpi values per kpi type and owner.

I need to to a table that count the number of times that my values is less than 0, grouped by "Owner". Do you know which expression should i use?

Thank you

Re: CountIf Table

SabineOussi — Tue, 17 Jan 2017 13:47:27 GMT

Try using this measure

Number of negative = SUMX(VALUES(Table1[Owner]), CALCULATE(COUNTA(Table1[Value]), Table1[Value]<0))

Hope this helps!