Help with calculating %

[okiediver]

Hello! brand new here at DAX/Power Pivot and I am trying to calculate a % of total in the Data Model section.

I need a simple %calculation that shows the % of each category row to the grand total.

I have Percent:=count([ID])/[Requests]*100 I am getting a % but not for the grand total. Is there a way to do this?

Thanks for any help, I really appreciate it.

[Steve_D]

I'm not sure if this helps but, if I understand your example correctly what you are trying to ascertain (as an example) is the % the "On Boarding" type is of "Requests"? therefore, wouldn't it be;

Numerator: Count of Request Type = Count(Table[Req type])
Denominator: Count of All Request Types = Calculate( [Count of Request Type], All(Table[Req Type]))
and then;
% of Request = Divide([Count of Request Type], [Count of all Request Types])