Table visual filtered with slicer dim 1 and slicer dim 2, how to show all dim 2 values in table

[FatherTheWizard]

Table visual filtered with slicer dim 1 (client) and slicer dim 2 (product). How to show all dim 2 values in table despite the selection made in slicer?

Underlying data:

Report page selections and what I see currently:

What I would like to see:

And to be exact the "what I would like to see" should include IF statement: If selected client + product combo has sum of [value] >0 then show all the products listed in the table and the equivalent sum of [value]. So in above, as we have filtered client b and product 1, we know that sum of [value] = 20 which is >0 then we want to show the full table like in the expected results table.

[parry2k]

@FatherTheWizard ok so

option 1 -> if the client is selected then show everything for that client even a product is selected,

option 2 -> if a product is selected, show everything for that product and ignore what is selected in the client slicer

so what supersedes another, if the value from both the slicer is selected, option 1 or option 2 ??

[FatherTheWizard]

Can you show at least the version where user only does a selection to Product slicer and the end-result table shows all the sales for the clients that have sales for the selected product? So basically selecting the product from slicer should only do the indirect selection of clients. 

As in my previous message the example there was a selection Product = "1". With example data there were sales for 3 clients (a, b and d). End result in that case would be showing ALL sales for there 3 clients (because these are the clients that have sales for the selected product "1").

[FatherTheWizard · Accepted solution]

Okay I solved this issue with a bridge table in a following way. Still appreciate if someone can comment how good or bad practise this is generally. 

Model looks the following:

And report page looks like this. Dim Product in this narrow use case is irrelevant but I left it in the picture.

[parry2k]

@FatherTheWizard what's the point of having a product slicer if you want to see all the products for the selected client?

[FatherTheWizard]

I may want to rephrase this with another example:

Select only from product slicer, in this case "1".

-> We can see value for a, b and d clients. What I would like to see here is sales for ALL products for these clients that were recognized to have sales for the selected product 1. So the IF statement is sum([value])>0 (with the current selections) then show sales for all products (i.e. remove product filter from the end results table)

Underlying data for these clients (i.e. the expected end results in the visual table):