Forum Discussion
How to do a Count IF with condition using measure?
Hello, I need to get a count of employee numbers that are greater than 0 on Average variance, but I am getting an error. Can anybody please help me how to fix it? Avg_Daily_Var._ % = IFERROR(...
Hi,
Try these measures:
Avg_Daily_Var._ % = DIVIDE([Avg_Daily_Submitted],[Avg_Daily_Reqquired],0)CountEmp# = COUNTROWS(FILTER(VALUES(Employee[firstlast]),[Avg_Daily_Var._ %] >0.0))Hope this helps.
Anonymous , you might want to try
CountEmp#_2 = COUNTROWS ( FILTER ( VALUES ( Employee[firstlast] ), [Avg_Daily_Var._ %] < 0.0 && [Avg_Daily_Var._ %] > -0.10 ) )or equally
CountEmp#_2 = COUNTROWS ( FILTER ( VALUES ( Employee[firstlast] ), AND ( [Avg_Daily_Var._ %] < 0.0, [Avg_Daily_Var._ %] > -0.10 ) ) )
Anonymous , you might want to try
CountEmp#_2 =
COUNTROWS (
FILTER (
VALUES ( Employee[firstlast] ),
[Avg_Daily_Var._ %] < 0.0
&& [Avg_Daily_Var._ %] > -0.10
)
)or equally
CountEmp#_2 =
COUNTROWS (
FILTER (
VALUES ( Employee[firstlast] ),
AND ( [Avg_Daily_Var._ %] < 0.0, [Avg_Daily_Var._ %] > -0.10 )
)
)Awesome, thank you so much for the help.