cancel
Showing results 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

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

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.

Super User II

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.

Announcements