Changing Sales Ranks Depending on Slicer

Hi, Amine,

  Thanks for working up a sample for me.  But I have many slicers and I need the summary to sum up by ID when I show all categories. so, when no categories are chosen on the slicer, for instance, ID's 1 and 5 should have a summed sales total.

Allow me to be more thorough in my question. I have this data:

client     Sales    Category

1            $50       Foo

1            $100     Bar

2            $1000   Foo

3             $10      Bar

5             $50      Foo

5              $100   Bar

What I need is a summary table, which is easy to achieve, including the computed if/then (over $100) statement to discern fabulousness:

clientID          Sales      Rank    

1                   $150        Fabulous

2                   $1000      Fabulous

3                   $10         Orindary

5                   $150       Fabulous

However, if I choose "Foo" in the Category slicer, as Amine nicely put together in a sample for me, I need the Rank to recompute on the fly, like this example where I chose "Bar".

clientID       Sales      Rank

1                 $100      Fabulous 

2                  $0         Ordinary

3                  $10       Ordinary

5                  $100     Fabulous

Does this make sense?

I've tried CALCULATEDTABLE but it doesn't change values when I use slicers. I have about 10 slicers on this data. 

I've tried the SELECTED statements to no avail. 

What do you all think? I don't care if the answer is a table or pivot that recomputes with the slicer selections or a visualization, as long as I can show that last summary table example.