cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Sea_and_Anne Helper I
Helper I

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 which expression should i use?

 

 

CreateTable.png

 

 

 

 

Thank you

 

 

1 REPLY 1
SabineOussi Skilled Sharer
Skilled Sharer

Re: CountIf Table

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!

Helpful resources

Announcements
Announcing the New Spanish Forum

Announcing the New Spanish Forum

Do you need help in Spanish? Check out our new Spanish community section.

April 2020 Community Highlights

April 2020 Community Highlights

Info on our Super Users, MBAS content and badges, and updates to our support articles. - Read the full Community Highlights.

MBAS Gallery 2020

MBAS Gallery 2020

Watch Microsoft Business Applications Summit sessions on-demand.