Hi,
I have created a new measure using the 'is cutoff' measure.
**bleep** Sum = IF(HASONEVALUE(project[Prj Code]),
CALCULATE(
SUM(spend[Amount]), FILTER(
ALLSELECTED(project),
project[Rank] <= MAX(project[Rank]))
)
)
is cutoff = IF([**bleep** Sum] >[Selected cutoff], 1, 0)
Above cutoff = IF([is cutoff] = 0, SUM(spend[Amount]), BLANK())
Below cutoff = IF([is cutoff] = 1, SUM(spend[Amount]), BLANK())
Put both measures onto the same bar chart, to have a dynamically changing chart based on my two slicers.