Filter Table Data based on Dynamic Measure Value

[mohammedismail]

Hi,

I have a Dynamic Measure which is created from the What If Parameter

The below is my Measure, where Parameter value is %

Measure = DISTINCTCOUNT([Supplier_Name])*Parameter[Parameter Value]

So I get a Value lets Say 300 from the measure.

I have a transaction table Called 'SPEND' where I have a column 'RANK' and the values in this column are ranging from 1 to 5000

I want to Filter the Data in the SPEND table based on the Measure..If my measure if 300, I only want the RANK column to show me the 1 to 300 values.

Please can someone help.