Calculated Column - True False based on Order value

[Anonymous]

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!

[Anonymous]

@jppv20    Sure!     

Order Number   Order Value  OVER 75K

A-124                   78,909           TRUE

A-326                   67,098           FALSE

C-568                   75,004           TRUE

[jppv20 · Accepted solution]

@Anonymous 

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]

Hi @Anonymous ,

Can you provide some example data and expected output?