Forum Discussion

ania_roh's avatar
ania_roh
Icon for Helper III rankHelper III
4 years ago

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 ...
Need Help
ania_roh's avatar
ania_roh
Icon for Helper III rankHelper III
4 years ago

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

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    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