Forum Discussion
Helper IRestrict filter values based on a measure
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!
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])
1 Reply
- amitchandak
Super User
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])