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...
qwk's avatar
qwk
Helper I
6 years ago

Hi,

Is there an expert out ther who can help me solve this issue.

Please keep in mind that the data source is OLAP .. I need a Running Total Formula in Power BI on an OLAP Measure.

N.B. DAX Sum function does not work on a measure having OLAP as a data source.

Thanks

  • qwk's avatar
    qwk
    Helper I
    6 years ago

    Thanks for your feedback.

    I have created a dataset connected to a live connection to Olap using the gateway.

    I build my reports of the dataset which in turn I am able to create formual on OLAP measures, simple measures or a bit more complex such as "Percentage Of Totals".

    Now I need to find a way to create a running total, I am sure there is a solution.

    Regards

    • FarhanAhmed's avatar
      FarhanAhmed
      Community Champion
      5 years ago

      You cannot create Calculated Members in Power BI Desktop using Live connection that you normally create under Excel OLAP tools.

      unfortunately, you need to create such calculations at SSAS level. 

      • qwk's avatar
        qwk
        Helper I
        5 years ago

        If you read the full thread you will see that I am able to create fomulas with a live connection to OLAP THROUGH A DATASET USING A GATEWAY.

        THANKS