cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
texmexdragon
Super User
Super User

Calculated Column - True False based on Order value

Hello Community  -  I know this should be easy, but...

 

I have an orders table out of our ERP system.   I need to create a "flag" that allows the user to have a slicer with the two options:  Over $75k, or Equal/Less $75k.   

 

In other words, imagine you have the orders table, and you quickly want to filter down to all Orders with a total value over 75,000 dollars...or....select all orders with a value below 75,000.    

 

And the key is that this should be at the Order level  (not at the line level).   

 

Thanks for any help!

 

 

1 ACCEPTED SOLUTION

@texmexdragon 

 

This formula should work:

OVER 75K = IF('Table'[Order Value]>75000,"True","False")
 
Or you can use this formula:
OVER 75K = 'Table'[Order Value]>75000
 
If I answered your question, please mark it as a solution to help other members find it more quickly.
 

View solution in original post

3 REPLIES 3
texmexdragon
Super User
Super User

@jppv20    Sure!     

 

Order Number   Order Value  OVER 75K

 

A-124                   78,909           TRUE

A-326                   67,098           FALSE

C-568                   75,004           TRUE

@texmexdragon 

 

This formula should work:

OVER 75K = IF('Table'[Order Value]>75000,"True","False")
 
Or you can use this formula:
OVER 75K = 'Table'[Order Value]>75000
 
If I answered your question, please mark it as a solution to help other members find it more quickly.
 
jppv20
Solution Sage
Solution Sage

Hi @texmexdragon ,

 

Can you provide some example data and expected output?

 

Helpful resources

Announcements
Carousel_PBI_Wave1

2023 Release Wave 1 Plans

Power BI release plans for 2023 release wave 1 describes all new features releasing from April 2023 through September 2023.

Power BI Summit Carousel 2

Global Power BI Training

Make sure you register today for the Power BI Summit 2023. Don't miss all of the great sessions and speakers!

Thank you 2022 Review

2022 Monthly Feature Releases

We had a great 2022 with a ton of feature releases to help you drive a data culture.