Countifs Question

[revasree]

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

[Nathaniel_C · Accepted solution]

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