Dear community,
I have a table with a list of proyect. Each proyect have a status like "Complete" or "In progress". So, i need to list this status by proyect in a simple table but with the dax measure cant do that. Obviously i have a mistake in dax but i dont know how solve this.
Important: each proyect is called from different Excel tables.
The proyect summary table and the think that i need to show is:
| Proyect (summary of list of protect) | Status (i need to show) |
| Proyect 1 | Complete |
| Proyect 2 | In progress |
| Proyect 3 | In progress |
| . | . |
| . | . |
| Proyect n | Complete |
The think that i try:
I take the status of single proyect with this dax measures:
ESTATUS PROYECTO 1= VAR estatus_protecto1= IF(OR ( SUM(estatus_proyecto[STATUS]) = 68, (CALCULATE(COUNTA(estatus_proyecto[STATUS]),estatus_proyecto[STATUS] = 1)) = 0 ) ,"Cerrado","En proceso") return estatus_proyecto1 |
The first statement is a SUM function. If SUM of the column estatus_proyecto is 68 or in each row dont have a 1 value return "Complete", else "In progress". If i put this function out of table, the result is correct.
When i build a advanced dax function with the function SELECTEDVALUE and SWITCH, the result is a wrong visualization.
This dax measures is:
ESTATUS GENERAL = VAR estatus_proyectoA= IF( OR ( SUM(estatus_proyecto1[STATUS]) = 68, (CALCULATE(COUNTA(estatus_proyecto1[STATUS]),estatus_proyecto1[STATUS] = 1)) = 0 ),"Cerrado","En proceso" ) VAR estatus_proyectoB= IF(OR( SUM(estatus_proyecto2[STATUS]) = 68, (CALCULATE(COUNT(estatus_proyecto2[STATUS]),estatus_proyecto2[STATUS] = 1)) = 0 ),"Cerrado","En proceso" )
VAR Seleccion = SWITCH( SELECTEDVALUE(Tabla15[Proyectos]), "Proyecto1",estatus_proyectoA, "Proyecto2",estatus_proyectoB ) return Seleccion |
The result is the next table:
| Proyect | Status with dax measures | Correct status |
| Proyect1 | In progress | Complete |
| Proyect2 | In progress | In progress |
| Protect3 | In progress | Complete |
| Protectn | Complete | In progress |
Please, i need you help . Since last week cant finish this report because of this.
Thanks a lot
Best regards
