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 whi...
Hi, Anonymous , you might want try this measure,
Balance Above Threshold = VAR __th = [High Rate Threshold] RETURN CALCULATE ( SUM ( Sheet1[Balance] ), Sheet1[Rate] > __th )
