Calculate PlaceHolder error

[feralvarez994]

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 that meet certain condition it appears an error that tells me that i have used a placeholder function in a true/false condition.

I want to count the quantity of sucursals that have the ObjT C/CSI > BENEF BRUTO TALLER, or the ones that have the %OBJT C/CSI >0, the thing is that the sucursals are no related to those functions, i have just made some dax with selectedvalue but theres no relationship in there. I have tried to count them with this formula but it doesnt work

Contar Sucursales Alcanzan CSI =

-- CALCULAR LA CANTIDAD DE SUCURSALES QUE ALCANZAN EL CSI

CALCULATE

    (DISTINCTCOUNT(TALLER[SUCURSAL]),

        [%ObjT C/CSI] > 0)

Im attaching the PBI FILE, this table is in the sheet COLABORADORES

Thanks everyone!

[feralvarez994]

Anyone that can help me? I still couldnt figured it out

[Anonymous]

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]

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