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.
I need the sum of all "utilization" values, and if the sum is positive, I need this measure to evaluate to "Over", if negative, it should evaluate to "Under"
So lets say for 'Utilization'[Equipment], there are years worth of daily [Utilization] entries, both positive and negative. If the date slicer on my report is filtered to "Last 1 Week", I want this measure to sum up the utilization for each piece of equipment in time frame, and evaluate to either "Over" or "Under" based on whether or not the calculated sum is > 0.
For this to work, the only columns I would need to work with are 'Utilization'[Equipment] and 'Utilization'[Utilization], right? Or do I need to include the date filter somewhere in the calculation? Could someone walk me through the logic behind this?
I am new to Power BI and DAX, so I am not totally sure how to accomplish this.
EDIT:
Ok I not thinking about this exactly right.
Here is the code that created an acurate measure:
UtilStatus = IF(SUM(Utilization[Utilization]) = 0, "", IF(SUM(Utilization[Utilization]) > 0, "Over", "Under"))
So if the row evaluates to Zero, it does nothing, If it is greater than Zero, it is over, and it is under if negative.
How can I use this in a slicer? I want to filter on rows that evaluate to Over or Under with a two button slicer. Is this doable?
@whodis118 , For slicer, you need dynamic Segmentation like
Customer Retention with Dynamic Segmentation, New/Lost/Retain Customer Count: https://www.youtube.com/watch?v=W4EF1f_k6iY
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 |
---|---|
45 | |
25 | |
19 | |
16 | |
8 |
User | Count |
---|---|
65 | |
50 | |
45 | |
20 | |
17 |