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

The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. Register Now

Reply
Anonymous
Not applicable

Show when either or both columns are greater than a value

Hello, 

 

I have two columns with different values and I am trying to filter it so that I can only see the rows when the amount of both or either is greater than 5000. 

I am trying to create a slicer or a visual filter. 

 

For example on the following table, I just want to see the rows in green. 

 

CreditDebit
05500
10000
60000
50005000
03000

 

Basically, if the sum of both is greater than 5000 then I just want to see those value. 

I have a calculated column with the sum of the debit and credits. I have tried filtering it so that I have values >5000 but it gives me back wrong info.

2 ACCEPTED SOLUTIONS
Anonymous
Not applicable

Hello @Anonymous,

 I think this is what you are trying to do. 

 

if you have your graph and simply create a third calculated column with this line:

 

result = IF(Table1[credit] + Table1[debt] >= 5000 , true,false)
(this take the sum of the two columns and if there = or greater than, it returns true. else returns false
 
next creat a slicer and put this result column into the slicer. i have pictures here. 
 
let me know if you have any questions, hope it helps. 
 
regards, 
  -Collin
creditttttttttt.PNGcredittttttt.PNG

View solution in original post

Anonymous
Not applicable

@Anonymous

not exactly sure what you mean, but if you mean like multiple tables of credit and debit columns, i would concider merging the columns,  if you mean adding more columns or data, like many savings for example, you would just add more measures to the slicer

 

if you need more help on this, i would suggest creating a new question so it does not give mixed results for this posted question.

hope this helps. 

 

best regards, 

- Collin

 

View solution in original post

3 REPLIES 3
Anonymous
Not applicable

Hello @Anonymous,

 I think this is what you are trying to do. 

 

if you have your graph and simply create a third calculated column with this line:

 

result = IF(Table1[credit] + Table1[debt] >= 5000 , true,false)
(this take the sum of the two columns and if there = or greater than, it returns true. else returns false
 
next creat a slicer and put this result column into the slicer. i have pictures here. 
 
let me know if you have any questions, hope it helps. 
 
regards, 
  -Collin
creditttttttttt.PNGcredittttttt.PNG
Anonymous
Not applicable

It worked, thanks!

 

Question: 

I want to do this for multiple tables and values. Would I need to create a new column/measure for each new value?

 

Anonymous
Not applicable

@Anonymous

not exactly sure what you mean, but if you mean like multiple tables of credit and debit columns, i would concider merging the columns,  if you mean adding more columns or data, like many savings for example, you would just add more measures to the slicer

 

if you need more help on this, i would suggest creating a new question so it does not give mixed results for this posted question.

hope this helps. 

 

best regards, 

- Collin

 

Helpful resources

Announcements
Fabric Community Conference

Microsoft Fabric Community Conference

Join us at our first-ever Microsoft Fabric Community Conference, March 26-28, 2024 in Las Vegas with 100+ sessions by community experts and Microsoft engineering.

February 2024 Update Carousel

Power BI Monthly Update - February 2024

Check out the February 2024 Power BI update to learn about new features.

Fabric Career Hub

Microsoft Fabric Career Hub

Explore career paths and learn resources in Fabric.

Fabric Partner Community

Microsoft Fabric Partner Community

Engage with the Fabric engineering team, hear of product updates, business opportunities, and resources in the Fabric Partner Community.