Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
badtuffstuff
Frequent Visitor

Matrix subtotal Percentages not Calculating correctly.

Hello,

badtuffstuff_0-1606853988335.png

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

1 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



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

View solution in original post

4 REPLIES 4
TomMartens
Super User
Super User

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

Here is the dax. It is a column. 

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

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

Thank you so much this worked perfectly.

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.