Help ignoring a slicer

[lekkerbek]

Hi,

I have a question about ignoring a slicer.

I have a dim table which shows:

- customer code

- customer name

- customer group

Multiple customers can be part of 1 group or not (in that case it's blank).

I have a fact table which shows:

- customer code

- other data not important for this question

I created a report which shows all relevant data for a customer using a slicer which is based on customer name. Standard stuff.

I would like to add a table to the page which basically shows all customers that belong to the same group.

Obviously when I do that now I only see one line being the customer that I selected

When I edit interactions and remove the filter, it shows all customers.

The desired outcome should be something like this:

Any ideas?

[SamWiseOwl · Accepted solution]

Hi @lekkerbek 

The easiest way to do this is duplicate the customer and group column into a seperate table.

Don't join this on to your existing table and then put that in your slicer.

Then you can create a measure to filter the data.

Add the measure into your Filter Pane under Filters on this visual.

filter measure =
var curr =SelectedValue(table[duplicated customer group])

Return
IF( SelectedValue(table[original customer group]) = curr, "Y")

Then filter this to Y

[lekkerbek]

Works like a charm. Thanks a million!