Generate dynamic exclude table

[Anonymous]

Hi,

I am trying to generate a dynamic table shows the inverted result of a slicer.

In order to obtain this, I used the follow measures/tables:

The original table for which I am trying to make the inverted selection

Cars_table

Table for slicer

Unique_brand = SUMMARIZE('Cars_table','Cars_table'[brand])

List of all selected values

selection_list = 

VAR part_1 = CONCATENATE(UNICHAR(34),UNICHAR(44))

VAR part_2 = CONCATENATE(part_1, UNICHAR(34))

VAR core = CONCATENATEX(Unique_brand, [brand], part_2)

VAR with_lead = CONCATENATE(UNICHAR(34), core)

VAR with_tail = CONCATENATE(with_lead, UNICHAR(34))

RETURN with_tail

Table with result I want to obtain

Result_table= FILTER(

ALL('Cars_table'),NOT CONTAINSROW({selection_list}, 'Cars_table'[brand]))

However, the result table does not seem to interpret the 'selection_list'. There are no errors, but there is no filtering going on either...

Any help would be greatly appreciated. 

[Mariusz]

Hi @Anonymous 

Can you create a small data sample and expected outcome?

Best Regards,
Mariusz

If this post helps, then please consider Accepting it as the solution.

Please feel free to connect with me.

[Anonymous]

Thank you! I solved it by using a measure in a table.

[Mariusz · Accepted solution]

Hi @Anonymous 

Tables and Columns are not dynamic therefore you will not see an impact from slicer selection.

You can, however, use the result table in a Measure.

Best Regards,
Mariusz

If this post helps, then please consider Accepting it as the solution.

Please feel free to connect with me.