topic Re: Calculate PlaceHolder error in DAX Commands and Tips

Calculate PlaceHolder error

feralvarez994 — Wed, 16 Nov 2022 20:32:33 GMT

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!

Re: Calculate PlaceHolder error

Anonymous — Thu, 17 Nov 2022 09:01:29 GMT

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.

Re: Calculate PlaceHolder error

feralvarez994 — Thu, 17 Nov 2022 12:48:05 GMT

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

Re: Calculate PlaceHolder error

feralvarez994 — Tue, 22 Nov 2022 17:27:06 GMT

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