Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
114 | |
99 | |
83 | |
70 | |
60 |
User | Count |
---|---|
150 | |
115 | |
104 | |
89 | |
65 |