Percentage of grand total, Create a measure that can be used in another calculation

[Rogerh]

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

[negi007]

@Rogerh  use below measure

GT_% = SUM('%GT'[Orders_Count_Orders])/CALCULATE(SUM('%GT'[Orders_Count_Orders]),ALLSELECTED('%GT'))

[amitchandak · Accepted solution]

@Rogerh , Try a measure like

divide(sum(Table[Orders_Count_Orders]) , calculate(sum(Table[Orders_Count_Orders]) , allselected(Table)))

[Rogerh]

Perfect, thank you your help @amitchandak ! Saved me again 🙂