Help with calculating %

Anything related to PowerPivot and DAX Formuale
Posts: 1
Joined: Wed May 03, 2017 12:12 am

Help with calculating %

Postby okiediver » Wed May 03, 2017 12:25 am

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.
Capture.JPG (31.08 KiB) Viewed 1340 times

Posts: 52
Joined: Sun Jul 31, 2016 2:29 pm

Re: Help with calculating %

Postby Steve_D » Thu May 04, 2017 12:16 am

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])

Return to “PowerPivot/DAX”

Who is online

Users browsing this forum: No registered users and 3 guests