Forum Discussion

florguilla's avatar
florguilla
Regular Visitor
2 years ago
Solved

A function 'PLACEHOLDER' has been used in a True/False expression that is used as a table filter exp

Hi! I need to count "Estado", but this is a measure. I need to count the number of people who have "ESTADO": "AUTORIZADO", "EN PROCESO", ETC.  "estado" is a calculated measure: ESTADO = VA...
  • Anonymous's avatar
    Anonymous
    2 years ago

    Hi florguilla ,

     

    You can modify your formula like below to create calculated column, then create measures. You can refer to blew demo:

    ESTADO = 
    VAR CONDICIONN =
        [AUTORIZADOS máx. por Lockout/Tagout - Authorized Person] + 
        [AWARENESS máx] + 
        [TEST ONLINE] + 
        [SKILLS]
    RETURN
        SWITCH(
            TRUE(),
            CONDICIONN >= 4, "AUTORIZADO",
            CONDICIONN = 3, "EN PROCESO",
            CONDICIONN = 2, "EN PROCESO",
            CONDICIONN <= 1, "NO AUTORI"
        )
    

    Count AUTORIZADO = 
    CALCULATE(
        COUNTROWS('YourTable'),
        'YourTable'[ESTADO] = "AUTORIZADO"
    )
    Count EN PROCESO = 
    CALCULATE(
        COUNTROWS('YourTable'),
        'YourTable'[ESTADO] = "EN PROCESO"
    )
    Count NO AUTORI = 
    CALCULATE(
        COUNTROWS('YourTable'),
        'YourTable'[ESTADO] = "NO AUTORI"
    )

     

    Best Regards,
    Adamk Kong

     

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