Forum Discussion

Nero_Carbone's avatar
Nero_Carbone
Regular Visitor
2 years ago
Solved

Running Total per week/month

Hello,   I would like to have a measure in power pivot for the running total that behaves like the one in the normal pivot tables. For instance, in the pivot table below the value are shown as run...
"Data Model"
"DAX "
"Power Pivot"
Dax Power Pivot
Nero_Carbone's avatar
Nero_Carbone
Regular Visitor
2 years ago

Thanks for leading me on the right direction Greg_Deckler !

 

In the end i managed to accomplish what i needed with the following:

 

ActualsRunningTotal:=SUMX(FILTER(ALLSELECTED(Actuals),

'Actuals'[Date (Month Index)]=MAX(Months[MonthNum])&&

Actuals[WeekID]<=MAX(WeekID[WeekID])&&

YEAR(Actuals[Date])=MAX(WeekID[Year])),Actuals[CU])

 

I didn`t need to adapt the structure of the data model.

 

EDIT:

One more question please: despite using ALLSELECTED, it seems like the values don`t change when additional filters are applied to the context (e.g. adding the suppliers on the rows).

Before filters:

After detailing supplier:

 

How can i fix it please?

 

  • Greg_Deckler's avatar
    Greg_Deckler
    Icon for Community Champion rankCommunity Champion
    2 years ago

    Nero_Carbone Difficult to say. I would make sure that the proper relationships exist first. Often, when you see repeated values in a table it is the result of a missing or incorrect relationship.