Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!To celebrate FabCon Vienna, we are offering 50% off select exams. Ends October 3rd. Request your discount now.
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') )
)