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

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
carebear88
Frequent Visitor

Create a measure with only one statment ( IF, TRUE)

Hi guys!

 

I need help with something that seems so simple but I just can't figure it out. Please help me.

 

I have a row with columns that gives me values from 0 and up. I want to create a measure that only gives me the results that are 40 or higher. How can I create a simple DAX function that gives me the ability to only present the cases that have a value of 40 or higher?

 

Example of my columns and rows are:

Case type          Value(weight)

Incident              0

Incident              40

Near miss           380

Incident              2

Near miss           0

 

 

Thank you ❤️

 

2 REPLIES 2
HotChilli
Super User
Super User

Are you saying you want to return rows where value > 39?

In this case, it's not a measure you create but a table

 

New Table = FILTER(oldtable, oldtable[Value(weight)]  > 39)

Hi!

 

I want to return rows that are 40 or higher. 

 

Ok so I should add a new table with the following ; New Table = FILTER( Casetype,casetype[Value(Weigth)] >39)) ?

 

Thank you!

 

 

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors