cancel
Showing results for
Did you mean:
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
Solution Sage

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.

3 REPLIES 3
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

Solution Sage

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.

Solution Sage

Can you provide some example data and expected output?

Announcements

#### 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.

#### 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!

#### 2022 Monthly Feature Releases

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

Top Solution Authors
Top Kudoed Authors