Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hello Power BI Community,
I'm having trouble trying to work out how to create a measure that is a Persentage of a grand total so I can use the measure in another calculation. I know you can update a Measure to be a percentage of a grand total (as shown below) but I am unable to use that for the next calculation.
My table is currently set up as follows:
Weekday = from my Calander Table
Orders_Count_Orders = Measure for Total of Orders placed
The next column is what I want to change to be an actual measure but it is currently made up of the 'Orders_Count_Orders' using the drop down in the values to change it to the show value as a percentage of grand total
%GT Orders_Count_Orders = Measure for Total of Orders placed, show value as to percentage of grand total
Can someone please help me with the Dax code for making this measure?
Weekday | Orders_Count_Orders | %GT Orders_Count_Orders |
Mon | 932 | 15.49% |
Tue | 1160 | 19.28% |
Wed | 1118 | 18.58% |
Thu | 850 | 14.13% |
Fri | 770 | 12.80% |
Sat | 585 | 9.72% |
Sun | 601 | 9.99% |
Thank you in advance for any help
Roger
Solved! Go to Solution.
@Rogerh , Try a measure like
divide(sum(Table[Orders_Count_Orders]) , calculate(sum(Table[Orders_Count_Orders]) , allselected(Table)))
@Rogerh , Try a measure like
divide(sum(Table[Orders_Count_Orders]) , calculate(sum(Table[Orders_Count_Orders]) , allselected(Table)))
User | Count |
---|---|
98 | |
90 | |
78 | |
71 | |
64 |
User | Count |
---|---|
112 | |
96 | |
95 | |
67 | |
65 |