Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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
Solved! Go to 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
Proud to be a Super User!
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!