Forum Discussion

Sea_and_Anne's avatar
Sea_and_Anne
Icon for Helper I rankHelper I
9 years ago
Solved

CountIf Table

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 ...
  • SabineOussi's avatar
    SabineOussi
    9 years ago

    Hi Sea_and_Anne

     

    Try using this measure

     

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

    Hope this helps!

SabineOussi's avatar
SabineOussi
Icon for Skilled Sharer rankSkilled Sharer
9 years ago

Hi Sea_and_Anne

 

Try using this measure

 

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

Hope this helps!