cancel
Showing results for
Did you mean:
Highlighted
Frequent Visitor

## Countifs Question

Hello all

am new to power Bi and need help with a counter to Countifs in excel

=COUNTIFS(CompName!D:D,DirectorName!A6,Value!H:H,">=0",Value!H:H,"<=3.99")

I would like to find for each director, how many components value is >=0 &<= 3.99

1 ACCEPTED SOLUTION

Accepted Solutions
Super User IV

## Re: Countifs Question

`m9 = CALCULATE(COUNTROWS(DISTINCT(Table[Column])),Table[Value]<=3.99 && Table[Value]>0)`

Hi @revasree ,

You will need to give us more information to write this, but this is the basic IF. You will need to surround this with and IF(Company=x && Director = z) depending on your setup.

If this solves your issues, please mark it as the solution, so that others can find it easily. Kudos are nice too.
Nathaniel

Proud to be a Super User!

Super User IV

## Re: Countifs Question

`m9 = CALCULATE(COUNTROWS(DISTINCT(Table[Column])),Table[Value]<=3.99 && Table[Value]>0)`

Hi @revasree ,

You will need to give us more information to write this, but this is the basic IF. You will need to surround this with and IF(Company=x && Director = z) depending on your setup.

If this solves your issues, please mark it as the solution, so that others can find it easily. Kudos are nice too.
Nathaniel

Proud to be a Super User!

Announcements

#### Meet the 2020 Season 1 Power BI Super Users!

It’s the start of a new Super User season! Learn all about the new Super Users and brand-new tiered recognition system.

#### Super User Challenge: Can You Solve These?

We're celebrating the start of the New Super User season with our first ever Super User 'Can You Solve These?' challenge.

#### Power BI Desktop Update - February 2020

We are super excited for our update this month, as we are releasing two of our top community requests!