cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
PradipMCT Frequent Visitor
Frequent Visitor

Running total

Hello friends,

 

I am trying to calculate a running total based on orders table. 

 

I get wierd result. please check and help. i would like to get the running total based on category wise sales. 

 

here is the link to my powerbi file:

 

https://1drv.ms/u/s!ArDdiHvYfT0RgYwqe2eHCo64tUXfIg

 

Regards,

Pradip

4 ACCEPTED SOLUTIONS

Accepted Solutions
Super User
Super User

Re: 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




Lima - Peru
Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!




PradipMCT Frequent Visitor
Frequent Visitor

Re: Running total

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?Running total.PNG and why do we have to write calculate twice?

Super User
Super User

Re: Running total

@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 .

 

 




Lima - Peru
Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!




PradipMCT Frequent Visitor
Frequent Visitor

Re: Running total

Thanks Victor, 

 

That helps.

4 REPLIES 4
Super User
Super User

Re: 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




Lima - Peru
Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!




PradipMCT Frequent Visitor
Frequent Visitor

Re: Running total

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?Running total.PNG and why do we have to write calculate twice?

Super User
Super User

Re: Running total

@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 .

 

 




Lima - Peru
Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!




PradipMCT Frequent Visitor
Frequent Visitor

Re: Running total

Thanks Victor, 

 

That helps.