Forum Discussion

bhelou's avatar
bhelou
Responsive Resident
5 years ago
Solved

Running Total

Dear ,   Kindly i am trying to make a running total for the balance as shown in the image ,  it is based on a rank by vendor : i have tried a quick measure it wont give a rnning total correct nor...
Need Help
  • bhelou's avatar
    bhelou
    5 years ago

    Dear amitchandak 

    Thank you for the measure , i made it as follow and worked 

    Balance 1 =
    CALCULATE(
    SUM('Test'[Balance]),
    FILTER(
    ALLSELECTED(Test),Test[Rank_By_Vendor]<=MAX(Test[Rank_By_Vendor])))

    Many thanks for your help 

amitchandak's avatar
amitchandak
Super User
5 years ago

bhelou , you need to have some unique value for running total.

 

Try like

 

CALCULATE(
SUM('Test'[Balance]),
FILTER(
ALLSELECTED('Test'[TransactionLine_Unique]),
'Test'[TransactionLine_Unique]>= MIN(TransactionLine_Unique))
)

 

or


CALCULATE(
SUM('Test'[Balance]),
FILTER(
ALLSELECTED('Test'[TransactionLine_Unique]),
'Test'[TransactionLine_Unique]<= MAX(TransactionLine_Unique))
)

 

or

 

CALCULATE(
SUM('Test'[Balance]),
FILTER(
ALLSELECTED('Test'),
'Test'[TransactionLine_Unique]<= MAX(TransactionLine_Unique))
)

  • bhelou's avatar
    bhelou
    Responsive Resident
    5 years ago

    Dear amitchandak 

    Thank you for the measure , i made it as follow and worked 

    Balance 1 =
    CALCULATE(
    SUM('Test'[Balance]),
    FILTER(
    ALLSELECTED(Test),Test[Rank_By_Vendor]<=MAX(Test[Rank_By_Vendor])))

    Many thanks for your help