Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hello good morning, if someone could help me to solve this doubt.
What I want is to add the values of the % column taking into account the Req Padre column.
As shown in the picture
Hola buenos dias , si alguien me podria ayudar a resolver esta duda.
Lo que quiero es sumar los valores de la columna % teniendo en cuenta la columna de Req. Padre
Como se muestra en la imagen
This is what I have /Esto es lo que tengo
This is how I want it to appear / Así quiero que aparezca
Muchas Gracias
Something similar to this should get you what you want...
Measure = SUMX( SUMMARIZE(table,table[Req.Padre]), [% column])
This should iterate over your table and group the rows by the req.padre field and sum the %
Hello, thank you very much for answering, I think that this formula only works if the column % is a measure, but the data of the column % is taken from another table
Hola, muchas gracias por responder creo que esa formula solo funciona si la columna % es una medida , pero los datos de la columna % son sacados de otra tabla
It works with a column, try wrapping the column in the RELATED() function.
RELATED('Datos Oficinas'[%])
Hi, @Anonymous
Please check if the following code works.
Measure =
SUMX (
FILTER ( ALL ( 'Sabana Incidentes' ), [Req.Padre] = MAX ( [Req.Padre] ) ),
'Datos Oficinas'[%]
)
Best Regards,
Community Support Team _ Eason
It gives me an error, so I applied this formula but it does not add the values that are in the red box as shown in the image
Me da error , asi que aplique esta formula pero no me suma los valores que estan el cuadro rojo como se muestra en la imagen
User | Count |
---|---|
128 | |
108 | |
99 | |
65 | |
62 |
User | Count |
---|---|
136 | |
113 | |
102 | |
71 | |
60 |