Forum Discussion
A function 'PLACEHOLDER' has been used in a True/False expression that is used as a table filter exp
- Anonymous2 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 KongIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
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.