Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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 ❤️
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!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
47 | |
26 | |
19 | |
14 | |
10 |
User | Count |
---|---|
57 | |
49 | |
44 | |
18 | |
18 |