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.
Help with calculating %
Help with calculating %
- Attachments
-
- Capture.JPG (31.08 KiB) Viewed 751 times
Re: Help with calculating %
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])
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])
Who is online
Users browsing this forum: No registered users and 5 guests