Forum Discussion

Maurus's avatar
Maurus
Regular Visitor
5 years ago

Filtering table with a selected value

Hi,

 

I need to create a copy of Table1 with some selected rows only, based on the value of Table1[column1].

If that value were some constant 'a', I could write : Table2 = Filter('Table1', 'Table1'[column1] = a

 

However, the value 'a' is not a constant. It has to be selected by the user. So, (I guess) using a slicer.

 

The problem is that I can't use the function SELECTEDVALUE as it does not work. The value selected is not passed into the filter and Table2 is shown empty when I do the following: Table2 = Filter('Table1', 'Table1'[column1] = SELECTEDVALUE( 'some table column containing the values for the selection')

I also tried to first define a variable with SLECTEDVALUE() and use the vaiable into the command above, or with a measure defining SELECTEDVALUE().  Any solution including SELECTEDVALUE() is not working.

 

Any suggestion?

 

Many thanks.

-maurus.

Need Help

3 Replies

  • Maurus's avatar
    Maurus
    Regular Visitor
    5 years ago

    Hi Amit,  The slicer was a guess. It could be somethink else. Basically the question is:

      How do you copy part of a table (by part of I mean rows, i.e. all columns with just some rows) filtering on some "desired value selected by the user" ?

    • v-janeyg-msft's avatar
      v-janeyg-msft
      Community Support
      5 years ago

      Hi,  Maurus 

       

      I thought of a way to create parameters in pq, but this is not very convenient for users to change. If you can make it clear what you want to use table2 for, I think I might be able to help you think of a workaround.

       

      Best Regards

      Janey Guo

       

      If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.