Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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!
User | Count |
---|---|
42 | |
28 | |
24 | |
20 | |
16 |
User | Count |
---|---|
54 | |
35 | |
18 | |
18 | |
15 |