cancel
Showing results for
Search instead for
Did you mean: Frequent Visitor

## Matrix subtotal Percentages not Calculating correctly.

Hello, Why is the percentage column not recalculating the percentage instead of just adding them together?

1 ACCEPTED SOLUTION  Super User II

Hey @badtuffstuff ,

the DAX statement of calculated columns will be evaluated just during data refresh (and of course when the statement is changed during the development phase). Because of this, a calculated column is just a numeric value after the model is recalculated, the final phase of the data refresh.

Create a measure instead of a calculated column, use this DAX statement:

``````% TO LEADS GOAL 1 (ms) =
DIVIDE(
CALCULATE( SUM( MSR_POWERBI[MTD ACTUAL LEADS] ) )
, CALCULATE( SUM( MSR_POWERBI[MTD LEADS GOAL] ) )
)``````

Hopefully, this provides what you are looking for.

Regards,

Tom

Did I answer your question? Mark my post as a solution, this will help others!

Proud to be a Super User!
I accept Kudos 😉
Hamburg, Germany
4 REPLIES 4  Super User II

Hey @badtuffstuff ,

please provide the DAX statement that used to calculate the ratio. Also, provide the information if it's a

• calculated column, or a
• measure

My assumption - it's a calculated column, this will explain why the ratios are summed up.

Regards,

Tom

Did I answer your question? Mark my post as a solution, this will help others!

Proud to be a Super User!
I accept Kudos 😉
Hamburg, Germany Frequent Visitor

Here is the dax. It is a column.

% TO LEADS GOAL 1 = divide ( MSR_POWERBI[MTD ACTUAL LEADS] ,MSR_POWERBI[MTD LEADS GOAL])  Super User II

Hey @badtuffstuff ,

the DAX statement of calculated columns will be evaluated just during data refresh (and of course when the statement is changed during the development phase). Because of this, a calculated column is just a numeric value after the model is recalculated, the final phase of the data refresh.

Create a measure instead of a calculated column, use this DAX statement:

``````% TO LEADS GOAL 1 (ms) =
DIVIDE(
CALCULATE( SUM( MSR_POWERBI[MTD ACTUAL LEADS] ) )
, CALCULATE( SUM( MSR_POWERBI[MTD LEADS GOAL] ) )
)``````

Hopefully, this provides what you are looking for.

Regards,

Tom

Did I answer your question? Mark my post as a solution, this will help others!

Proud to be a Super User!
I accept Kudos 😉
Hamburg, Germany Frequent Visitor

Thank you so much this worked perfectly.  ## Helpful resources

Announcements #### Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group #### The largest Power BI virtual conference

100+ sessions, 100+ speakers, Product managers, MVPs, and experts. All about Power BI. Attend online or watch the recordings. #### Experience what’s next for Power BI

See the latest Power BI innovations, updates, and demos from the Microsoft Business Applications Launch Event. Top Solution Authors
Top Kudoed Authors
Users online (3,857)