Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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
Solved! Go to Solution.
Hi, @Anonymous , you might want try this measure,
Balance Above Threshold =
VAR __th = [High Rate Threshold]
RETURN
CALCULATE ( SUM ( Sheet1[Balance] ), Sheet1[Rate] > __th )
Thanks to the great efforts by MS engineers to simplify syntax of DAX! Most beginners are SUCCESSFULLY MISLED to think that they could easily master DAX; but it turns out that the intricacy of the most frequently used RANKX() is still way beyond their comprehension! |
DAX is simple, but NOT EASY! |
Hi, @Anonymous , you might want try this measure,
Balance Above Threshold =
VAR __th = [High Rate Threshold]
RETURN
CALCULATE ( SUM ( Sheet1[Balance] ), Sheet1[Rate] > __th )
Thanks to the great efforts by MS engineers to simplify syntax of DAX! Most beginners are SUCCESSFULLY MISLED to think that they could easily master DAX; but it turns out that the intricacy of the most frequently used RANKX() is still way beyond their comprehension! |
DAX is simple, but NOT EASY! |
User | Count |
---|---|
47 | |
26 | |
22 | |
17 | |
15 |
User | Count |
---|---|
53 | |
34 | |
17 | |
17 | |
15 |