Forum Discussion

feralvarez994's avatar
feralvarez994
Icon for Helper II rankHelper II
3 years ago

Calculate PlaceHolder error

Hi everyone! Im struggling with this Dax measure. I want to count the distinct sucursal that reach certain value, i have made a table that got the right measures but when i try to count the sucursals...
Anonymous's avatar
Anonymous
Not applicable
3 years ago

Hi feralvarez994 ,

 

Please try this code.

Contar Sucursales Alcanzan CSI = 
-- CALCULAR LA CANTIDAD DE SUCURSALES QUE ALCANZAN EL CSI
CALCULATE
    (DISTINCTCOUNT(TALLER[SUCURSAL]),
       FILTER(TALLER, [%ObjT C/CSI] > 0))

Result is as below.

 

Best Regards,
Rico Zhou

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

 

 

 

feralvarez994's avatar
feralvarez994
Icon for Helper II rankHelper II
3 years ago

Hi Anonymous , i have tried that also but the thing is that there are only 3 TALLERS with %OBJT C/CSI > 0 instead of 6, i dont know which filter is not having in context