Forum Discussion

qwk's avatar
qwk
Helper I
6 years ago

Running Total - Data Source SSAS MutiDimensional Cube

Hi, I would like to create a formula to calculate a Running Total in a Power BI Report. The source is a DataSet having a direct connection to an SSAS MultiDimensional Cube. I tried using Quick Measu...
amitchandak's avatar
amitchandak
Super User
6 years ago

qwk , try like

 

Cumm Sales = CALCULATE(SUM(Table[net Sales]),filter(all(Table),Table[net Sales] <=max(Table[net Sales])))

  • qwk's avatar
    qwk
    Helper I
    6 years ago

    Unfortunately since the data source is a multi-dimensional cube the SUM function doe not work.

    Thanks