Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi
I have created a table in Power BI Desktop and have dropped some fields into that report, which I am happy with. I want to add another column, but be able to do some formulas but I am unsure of how to do that.
Specifically, what I was trying to do is common size the data There is a list of values and a SUM at that bottom, I wanted to divided each value by the sum so that I could see the percentage of each value of the total. How would I go about doing that?
Thanks,
Solved! Go to Solution.
You can try duplicate the sum field on the table then just choose to show value as percent of grand total? That saves you having to do any new columns or measures.
You can try duplicate the sum field on the table then just choose to show value as percent of grand total? That saves you having to do any new columns or measures.
User | Count |
---|---|
93 | |
83 | |
77 | |
75 | |
66 |
User | Count |
---|---|
115 | |
105 | |
93 | |
65 | |
60 |