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,
I have a problem with calculate and I can´t find the solution, I hope you can help me, I would be very appreciate.
I use the table "imputaciones" in all my visualization, I mean, all I use in my visualization comes from one table:
Nombre comes from the table imputaciones [Nombre]
Nombre_departamento : imputaciones [Nombre_departamento]
Proyecto nombre: Imputaciones [Proyecto_nombre]
and then I have two measure: Horas NPD which calculates hours from the table imputaciones and horas totales (and here is the problem)
I put calculate with "all" to ignore the name of proyect and the name of department ( I mean, I would like to have always the total there for one person), I mean, it should be like that:
but it is not.
I have now different total for the same person, although I put calculate with all there:
Why is it like that?
The selectors I use, all use the table of imputations also,
I have somes filters (all with imputaciones table, apart of es_externo with is a table of personas)
I can´t find the error but it doens´t work as it should
I hope you can help me.
Thank you a lot
I found the reason but still I don´t know how I can solve it.
The reason is in the filter Horas NPD is not blank:
Before I put this filter because I didn´t wanted to have projects with horas npd blank. But that filter also affects in my horas totales. How can I do to not affect it? I mean,
I don´t want to see all that project with blank HORAS NPD,
but i always want to have the same calculation in horas totales.
how can i modify the measure to archive that?
Thank you
Hi @ania_roh ,
Try using ALL() function to wrap the whole table.
For example:
Measure = calculate(sum(value),FILTER(ALL(table),condition))
Best Regards,
Jay
@ania_roh Try ALLEXCEPT(Imputaciones[Nombre unificado])
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 |
---|---|
117 | |
101 | |
68 | |
68 | |
43 |
User | Count |
---|---|
146 | |
106 | |
105 | |
90 | |
65 |