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
    Icon for Community Champion rankCommunity 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
    Icon for Community Champion rankCommunity 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.