Forum Discussion

qwk's avatar
qwk
Icon for Helper I rankHelper 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
Icon for Super User rankSuper 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
    Icon for Helper I rankHelper I
    6 years ago

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

    Thanks