Forum Discussion
laurena022
3 years agoNew Member
Update Numerator and Denominator by Dynamic Filter in Power Query
I created a measure that divides two columns in the same table and updates the numerator & denominator with the selection of a dynamic filter. However, I want to move it over to the dataset via Power Query. Can anyone help "translate" this measure?
YE Target - Measure =
DIVIDE (
SUM ( 'PM 2023 Plan'[Year End Re-Forecast] ),
CALCULATE ( SUM ( 'PM 2023 Plan'[Year End Savings Target] ), ALLSELECTED ( 'PM 2023 Plan') )
)No RepliesBe the first to reply