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 =
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"
)
Can anybody help me?



  • 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.

2 Replies

  • foodd's avatar
    foodd
    Icon for Community Champion rankCommunity Champion
    2 years ago

    Hello florguilla, and thank you for sharing a question with the Community.  Please remember to adhere to the decorum of the Community Forum when asking a question.

    Please provide your work-in-progress Power BI Desktop file (with sensitive information removed) that covers your issue or question completely in a usable format (not as a screenshot). You can upload the PBIX file to a cloud storage service such as OneDrive, Google Drive, Dropbox, or to a Github repository, and then share a file’s URL.

    https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-p/963216

    Please show the expected outcome based on the sample data you provided.

    https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523/highlight/true#M607150

    This allows members of the Forum to assess the state of the model, report layer, relationships, and any DAX applied.

  • Anonymous's avatar
    Anonymous
    Not applicable
    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.