Forum Discussion
Solved
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,...
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
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