Percentage of grand total, Create a measure that can be used in another calculation
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?