Forum Discussion
Advocate VCube data- dynamic query selection based on a list of values ?
If you apply the filter as the first step, the query should still fold back to the server even without writing dedicated code.
But if for some reason this doesn't work, you can add a query record with a specific filtering command (https://community.powerbi.com/t5/Desktop/Passing-parameters-to-MDX-source-queries/td-p/98255 or https://community.powerbi.com/t5/Desktop/Parameterized-SQL-Query-with-query-folding/td-p/171503 )
Community ChampionIf you apply the filter as the first step, the query should still fold back to the server even without writing dedicated code.
But if for some reason this doesn't work, you can add a query record with a specific filtering command (https://community.powerbi.com/t5/Desktop/Passing-parameters-to-MDX-source-queries/td-p/98255 or https://community.powerbi.com/t5/Desktop/Parameterized-SQL-Query-with-query-folding/td-p/171503 )
Advocate VImkeF , v-piga-msft ,
Thank you so much for all the hints ! I have the solution with List.Contains as a first step in blank query :)
Big thank you!,
Karo