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?
