Calculating percentage grand total

[GarvitaSingh]

Hi Everyone, 

Here in the above screenshot, I tried calculating the values as the ''Percent of grand total'' in Power BI. But it's calculating column-wise only. I tried other options as well like show value as ''Percent of column total'' and ''Percent of row total''. 

I tried to populate the same thing in excel and I am able to do so. Please help me how to get the same excel result in Power BI. I am using table/matrix visuals in Power BI. 

Thanks in advance!

[GarvitaSingh]

Thank you very much @amitchandak for your help! 

I am facing one more problem, values in the above snapshot are not coming in sequence. The Datatype of the above column is text. How can I get them in sequence?

[amitchandak · Accepted solution]

@GarvitaSingh , for % of grand total, create a measure like

divide([measure], calculate([measure], allselected()) )

Percent of Total and Percent of SubTotal https://www.youtube.com/watch?v=6jTildcV2ho
https://www.youtube.com/watch?v=cN8AO3_vmlY&t=24270s