topic Re: A function 'PLACEHOLDER' has been used in a True/False expression that is used as a table filter exp in DAX Commands and Tips

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

florguilla — Sat, 06 Jul 2024 16:03:38 GMT

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?

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

foodd — Sun, 07 Jul 2024 15:33:48 GMT

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.

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

Anonymous — Mon, 08 Jul 2024 01:21:16 GMT

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.