Need percentage from a SSAS cube Measure column

[kamran]

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?

[Anonymous]

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