cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
parag123
Helper II
Helper II

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
Super User III
Super User III

Hi, @parag123 , you might want try this measure,

Balance Above Threshold =
VAR __th = [High Rate Threshold]
RETURN
    CALCULATE ( SUM ( Sheet1[Balance] ), Sheet1[Rate] > __th )

View solution in original post

2 REPLIES 2
CNENFRNL
Super User III
Super User III

Hi, @parag123 , you might want try this measure,

Balance Above Threshold =
VAR __th = [High Rate Threshold]
RETURN
    CALCULATE ( SUM ( Sheet1[Balance] ), Sheet1[Rate] > __th )

View solution in original post

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

Helpful resources

Announcements
PBI_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

Get Ready for Power BI Dev Camp

Microsoft named a Leader in The Forrester Wave

Microsoft received the highest score of any vendor in both the strategy and current offering categories.

Get Ready for Power BI Dev Camp

Power BI Dev Camp - September 30th, 2021

Mark your calendars and join us for our next Power BI Dev Camp!

PowerPlatform 768x460.png

Microsoft Learn

Check out our new Discover Your Career Path blog post series and get all the details.