How to create table base on slicer value

[wangjuan303]

I have a dashboard, need to show detail data, that detail data in a big volume table, it is from DB2, and direct query connection,  and it has many to many relationship with other table, so I cannot create relationship for detail table for report performance, 

so my plan is 

1. use Direct query connect this table. 

2. in the Power bi use Dax create filtered table from this connection, 

3. then from this filtered table create detail report. 

now I am stuck on step 2, when filter table, related value from Slicer, 

How I create  filtered table base on Slicer value ? 

when I create table with hardcode,  like this way it works : 

 Filter Table = FILTER(
    DimProduct,
    DimProduct[Color]='Red' 
    &&
    DimProduct[SizeUnitMeasureCode]='CM')

 when I create table with slicer value, it will show blank, 

 Filter Table = 
Var Color = SELECTEDVALUE ('Color'[Color])
Var Code = SELECTEDVALUE ('Code'[Code])
Return 
FILTER(
    DimProduct,
    DimProduct[Color]=Color
    &&
    DimProduct[SizeUnitMeasureCode]=Code)

 Is this code have any error? or when we create table not allow to use dynamic filter? 

please give me any suggestion, Thank you 

[parry2k · Accepted solution]

@wangjuan303 if you are using DQ, you can take advantage of Dynamic Parameters, not all the data sources are supported though. Dynamic M query parameters in Power BI Desktop (preview) - Power BI | Microsoft Docs

✨ Follow us on LinkedIn and  to our YouTube channel

I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!

⚡ Visit us at https://perytus.com, your one-stop shop for Power BI-related projects/training/consultancy.

[amitchandak]

@wangjuan303 , You can not use a slicer value in the calculated table