Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Anonymous
Not applicable

Display balance over custom threshold value

In trying to display balances per category based on user input threshold values.

 

parag123_0-1611155580343.png

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

1 ACCEPTED SOLUTION
CNENFRNL
Community Champion
Community Champion

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!

View solution in original post

2 REPLIES 2
CNENFRNL
Community Champion
Community Champion

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!

Anonymous
Not applicable

@CNENFRNL perfect!! I gotta start thinking out of the box.

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors