Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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)))
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
114 | |
99 | |
83 | |
70 | |
60 |
User | Count |
---|---|
150 | |
115 | |
104 | |
89 | |
65 |