Forum Discussion
problem with calculate
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
4 Replies
ania_roh Try ALLEXCEPT(Imputaciones[Nombre unificado])
Greg_Deckler thank you for your reply but it doens´t work neither 😞
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
