Forum Discussion

linkguic's avatar
linkguic
Regular Visitor
7 years ago

Can DAX Filter support dynamics filter expression

Hi experts,

 

I try to dynamics filter table results and show as another table.

 

Basically, i would like to create a new table "FT" using filter function, filter on table 'Original' with a dynamics filter expression on what i selected for able mySelection

 

FT = filter('Original','Original'[key] = SELECTEDVALUE(mySelection[Key])) 

 

But, it seems the PowerBI does not show the expected results.

If i change the filter expression to static one --- 'Original'[key] = "static selection", it works

 

Any idea?

 

How could i achieve such dynamic filtering?

 

Thanks

Rake

1 Reply

  • v-jiascu-msft's avatar
    v-jiascu-msft
    Microsoft Employee

    Hi Rake,

     

    I'm afraid we can't do that for now. The calculated table can't be filtered dynamically.

     

    Best Regards,

    Dale