Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hello,
Why is the percentage column not recalculating the percentage instead of just adding them together?
Solved! Go to 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
Hey @badtuffstuff ,
please provide the DAX statement that used to calculate the ratio. Also, provide the information if it's a
My assumption - it's a calculated column, this will explain why the ratios are summed up.
Regards,
Tom
Here is the dax. It is a column.
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
Thank you so much this worked perfectly.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
118 | |
104 | |
77 | |
73 | |
52 |
User | Count |
---|---|
145 | |
109 | |
109 | |
90 | |
64 |