Forum Discussion

sprakash1192's avatar
sprakash1192
Helper II
5 years ago
Solved

Filtering on running total values

I have a running total measure that calculates roll forward of my inventory - RollForward = CALCULATE( [Inv_Qty_Cont_Agg], FILTER( ALLSELECTED('Calendar'[CALDATE_0]), Calendar'[CALDATE_0]<= MAX...
Need Help
  • Anonymous's avatar
    Anonymous
    5 years ago

    Hi sprakash1192 ,

     

    I have built a data sample to test:

    You could use the following formula to filter RollForward <0

    RollForward = var _v= CALCULATE([Inv_Qty_Cont_Agg],FILTER(ALLSELECTED('Calendar'[CALDATE_0]),'Calendar'[CALDATE_0]<=MAX('Calendar'[CALDATE_0])))

return IF(_v>0,BLANK(),_v)
    Measure = IF(HASONEVALUE('Calendar'[CALDATE_0]),[RollForward],SUMX('Calendar',[RollForward]))

    Best Regards,
    Eyelyn Qin
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Hi sprakash1192 ,

 

I have built a data sample to test:

You could use the following formula to filter RollForward <0

RollForward = var _v= CALCULATE([Inv_Qty_Cont_Agg],FILTER(ALLSELECTED('Calendar'[CALDATE_0]),'Calendar'[CALDATE_0]<=MAX('Calendar'[CALDATE_0])))

return IF(_v>0,BLANK(),_v)
Measure = IF(HASONEVALUE('Calendar'[CALDATE_0]),[RollForward],SUMX('Calendar',[RollForward]))

Best Regards,
Eyelyn Qin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.