Restrict filter values based on a measure

[JGARROD]

Hi, 

I have a measure which calcuates Percentage complete of a data set. 

I have a table which stores the values 0%-100% at 1% incriments.

I want to put the table (0-100%) into a filter but have the the possible selected percentage numbers limited by the first measure.

E.G the percentage complete of a data set id 44%, when i look at the filter (based off of the Percentage table) i want the smallest number to be 44% (i.e because 44% of the data set is complete you cant ask for a less amount) 

Is this posible, could somoene help me please 

Thanks!

[amitchandak · Accepted solution]

@JGARROD , Based on what I got you can get an independent what if table, then you can create filter

row level

sumx(filter(Table, [Measure] > [whatifmeasure] ) , [Measure])

or on category/item/group level

sumx(filter(values(Table[Category]) , [Measure] > [whatifmeasure] ) , [Measure])

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