Forum Discussion
JGARROD
Helper I
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 b...
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])
amitchandak
Super User
Super UserJGARROD , 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])