Running total

PradipMCT

Hi, try with this:

Total sales running =
VAR TOT =
    CALCULATE ( SUM ( Orders[Sales] ) )
RETURN
    CALCULATE (
        [Total sales],
        FILTER ( ALLSELECTED ( 'Products2'[Sub category] ), [Total sales] <= TOT )
    )

Regards

Victor

Lima  Peru

Hi Victor,

Thanks for the solution. It did work. Thanks again for that. just a simple question,

I am trying to understand that function when removed the variable syntax and tried to do without it doesnt work, could you kindly explain? and why do we have to write calculate twice?

PradipMCT

The Var made a Calculate of Total Sales in this context. (Current Subcategory)

So The Filter Search all The  Subcategories with "Total-Sales"  Lower than the Total Sales of Actual Subcategory.

If you put directly in the filter its saying total Sales (Measure) are equal to Sum of Total Sales .

Thanks Victor, 

That helps.