how to ignore slicer in calculate

[liran]

hi, i am trying to create a measure that ignores a certain slicer, but will be affected from others.

i tried =calculate(distinctcount(Member),all(table)) but that return all the table but i want it to be affected by other slicers.

[vik0810 · Accepted solution]

Instead

calculate(distinctcount(Member),all(table))

try

calculate(distinctcount(Member), all(table[Column]))

[liran]

thank you! 

[tex628]

This is really messy, but I think i might know something close to a solution. 

First, it might be possible to do it with ALLEXCEPT() instead of ALL(). Just include every other filter and it might work. **bleep**ty solution tho.

Next... 

I dont know if this works because i've not tried it...

IF(SELECTEDVALUE([Column]);CALCULATE(DISTINCTCOUNT([Member];FILTER(ALL([Table]);SELECTEDVALUE([Column]))

What might not might not work is the filter(all(table);selectedvalue())
I dont know if it's possible to use the FILTER function on a table already affected by the ALL function...

Best of luck! 

/ Johannes

[liran]

yes it will work with the ALLEXCEPT and include all the filters i want, but i am trying to create a measure that is more flexible and that i wont need to add another value to the ALLEXCEPT every time.

i am trying to use SELECTEDVALUE but i can't find such formula

[Greg_Deckler]

Have a look at CALCULATETABLE function.

[liran]

how exactly? 

i also tried using keepfilter but i didn't succeed