Forum Discussion
florguilla
2 years agoRegular Visitor
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...
- 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.
Anonymous
2 years agoNot applicable
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.