Filtration on Measures

[ahadtk]

Dear All!

We have thousands of Materials with their prices over the time (Since 3 Years ago and continuing...) like below:

We have another table includes 8 measures (1 Day, 1 Week, 1 Month, 1 Quarter, 6 Months, 1 Year, 2 Years and 3 Years) which shows the price differential PERCENTAGE during the mentioned measures,

Now, we need showing the Specific Materials with specific price differential during the specific time duration, like below:

e.g. If I insert (-20) in the Min Percent and (10) in the Max. Percent and select (Week) in Duration fields, it should list all the materials that their price have been changed from (-20%) to (10%) in the past (Week).

Or:

If I insert (-5) in the Min Percent and (0) in the Max. Percent and select (Month) in Duration fields, it should list all the materials that their price have been decreased up to 5%  in the past (Month).

Many thanks,

[v-luwang-msft]

Hi @ahadtk ，

Please provide sanitized sample data that fully covers your issue.
https://community.powerbi.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-... 
Please show the expected outcome based on the sample data you provided.

https://community.powerbi.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523 

Best Regards

Lucien