Matrix subtotal Percentages not Calculating correctly.

[badtuffstuff]

Hello,

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

[TomMartens]

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

[badtuffstuff]

Here is the dax. It is a column. 

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

[TomMartens · Accepted solution]

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

[badtuffstuff]

Thank you so much this worked perfectly.