Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Calculating totals without row context limiting data

I've been attempting to find a solution for this for a while now and haven't been able to.   I'm trying to get the values for the Equipment_Days2 column to read: 14    associated with equipment_qt...
  • AlexisOlson's avatar
    AlexisOlson
    4 years ago

    This might get you a bit closer.

    Equipment_Days2 =
VAR CurrQty = CalculatedDaysTable[equipment_qty]
RETURN
    CALCULATE (
        SUM ( CalculatedDaysTable[DaysValue] ),
        CalculatedDaysTable[equipment_qty] <= CurrQty,
        CalculatedDaysTable[equipment_uom] = "Daily"
    )

     

    You used ALL on the entire table, which removes the context from all columns. I'd recommend only using it for specific columns unless you really do want to get rid of all the filtering.

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Unfortunately this results in the exact same output as I've been continuously getting, with the additions not being cumulative.

 

Anonymous's avatar
Anonymous
Not applicable
4 years ago

This formulation did work once it was converted to a measure.

 

Equipment_Days = VAR CurrQty = max(CalculatedDaysTable[equipment_qty])
RETURN
CALCULATE (
SUM (CalculatedDaysTable[DaysValue]),
CalculatedDaysTable[equipment_qty] >= CurrQty &&
CalculatedDaysTable[equipment_uom] = "Daily"
)
 
Thank you for pointing me in the right direction.