topic Re: Generate dynamic exclude table in DAX Commands and Tips

Generate dynamic exclude table

Anonymous — Tue, 29 Oct 2019 06:02:06 GMT

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 — Tue, 29 Oct 2019 08:34:59 GMT

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.

Mariusz — Thu, 31 Oct 2019 08:48:07 GMT

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 — Wed, 06 Nov 2019 01:21:02 GMT

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