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