Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Generate dynamic exclude table

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. 

  • 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 Repczynski

     

3 Replies

  • Mariusz's avatar
    Mariusz
    Community Champion

    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 Repczynski

     

  • Mariusz's avatar
    Mariusz
    Community Champion

    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.
    Mariusz Repczynski

     

    • Anonymous's avatar
      Anonymous
      Not applicable

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