Is it possible to sum only the no hide values?

Hello good morning,

I need help with the sum of the visible cells of a calculation. I need to know how to make the sum of the visible cells with the option (hide value) not (hide member).

I have tried the following calculation sum(0, all(v), 0), but it only works with hide members values.

It is possible to make a summation of only the no hide values.

Excuse me for my bad English...



1 comment
  • Hi Tomás, unfortunately the v does not work at this point. I only know this workaround with a calculated measure as helper column. 



     A total can now be displayed, but a count unfortunately does not work. But maybe it helps for your case. 


Please sign in to leave a comment.

Didn't find what you were looking for?

New post