Forum Discussion

Brotedo's avatar
Brotedo
Helper I
4 years ago
Solved

Running Total in Matrix with Multiple Rows

I have a matrix in PowerBI with two row filters (name and team) and columns as 12 dates starting from current month. I have a measure that I display for each month, but I want it to display as a runn...
  • v-chenwuz-msft's avatar
    v-chenwuz-msft
    4 years ago

    Hi Brotedo ,

     

    Can you try ALLSELECTED() to do this. Before this, you need create a dim_date table for your fact table. Use the values() to create the dim table which likes the below.

     

    date = VALUES('Planning'[Month])

     

    Then create a mesure to calculate.

     

    c =
CALCULATE (
    SUM ( 'Table'[Values] ),
    FILTER ( ALLSELECTED ( 'date'[Month] ), [Month] <= MAX ( 'date'[Month] ) )
)

     

     

    Result:

     

    Pbix in the end you can refer.

    Best Regards

    Community Support Team _ chenwu zhu

     

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

v-chenwuz-msft's avatar
v-chenwuz-msft
Community Support
4 years ago

Hi Brotedo ,

 

Can you try ALLSELECTED() to do this. Before this, you need create a dim_date table for your fact table. Use the values() to create the dim table which likes the below.

 

date = VALUES('Planning'[Month])

 

Then create a mesure to calculate.

 

c =
CALCULATE (
    SUM ( 'Table'[Values] ),
    FILTER ( ALLSELECTED ( 'date'[Month] ), [Month] <= MAX ( 'date'[Month] ) )
)

 

 

Result:

 

Pbix in the end you can refer.

Best Regards

Community Support Team _ chenwu zhu

 

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