Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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?
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
User | Count |
---|---|
125 | |
106 | |
99 | |
63 | |
62 |
User | Count |
---|---|
135 | |
116 | |
101 | |
71 | |
61 |