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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
Anonymous
Not applicable

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

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

View solution in original post

3 REPLIES 3
Anonymous
Not applicable

@jppv20    Sure!     

 

Order Number   Order Value  OVER 75K

 

A-124                   78,909           TRUE

A-326                   67,098           FALSE

C-568                   75,004           TRUE

@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
Solution Sage
Solution Sage

Hi @Anonymous ,

 

Can you provide some example data and expected output?

 

Helpful resources

Announcements
Fabcon_Europe_Social_Bogo

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

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

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.