Forum Discussion
Display balance over custom threshold value
In trying to display balances per category based on user input threshold values.
In the above scenario,
High Rate Threshold = Rate Multiplier * Avg Rate
I'm trying to display Balances which have 'Rates' above 'high rate threshold'.
To achieve this, I've used following DAX expression:
Balance Above Threshold = CALCULATE(SUM(Sheet1[Balance]), FILTER(Sheet1,Sheet1[Rate]>[High Rate Threshold]))
But this doesn't seem to be working correctly. Please let me know what modifications do I need to make to the DAX expression or any alternate approach.
PBIX File attached here: https://drive.google.com/file/d/13ByNap4EtLJFY05AJ5WVMDfazX5dmZVG/view?usp=sharing
Hi, Anonymous , you might want try this measure,
Balance Above Threshold = VAR __th = [High Rate Threshold] RETURN CALCULATE ( SUM ( Sheet1[Balance] ), Sheet1[Rate] > __th )
