Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

How to create custom filter

Hello. I have two tables. First has product id and appropriate value, while the second has countries which have made the trade. So if I select one product the second table shows countries which have ...
Need Help
v-lili6-msft's avatar
v-lili6-msft
Community Support
5 years ago

hi  Anonymous 

For your case, you need to create a parameter for a slicer, you could just use what if parameter to get it.

https://docs.microsoft.com/en-us/power-bi/transform-model/desktop-what-if

 

Then use this parameter measure as a conditional as below:

Measure = SUMX(FILTER(VALUES('Table'[product id]),[Total values]>[Parameter Value]),[Total values])

If you still have problem, please share your sample pbix file and your expected output. 

 

Regards,

Lin