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 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!

3 Replies

  • 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