Forum Discussion

kamran's avatar
kamran
Frequent Visitor
9 years ago

Need percentage from a SSAS cube Measure column

Hi

 

I've a measure column "Sales" being fetched from a SSAS cube. I need to take percentage of individual Product's sales out of total sales. My values are like

 

Product         Sale
A                   10
B                    20

I've tried to use Measure Column as well as New Column options in Power BI and adding formula as:

 

SalePercentage = ( Sale / SUM(Sale) ) * 100

But formula raises an error.

 

Can you please tell me what I am doing wrong?

Need Help

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable
    9 years ago

    Hi kamran,

    What error message do you get?

    I create a column using your formula, everything works well, please see my example.


    Thanks,
    Lydia Zhang