Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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.
User | Count |
---|---|
125 | |
106 | |
99 | |
63 | |
62 |
User | Count |
---|---|
135 | |
116 | |
101 | |
71 | |
61 |