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

Score big with last-minute savings on the final tickets to FabCon Vienna. Secure your discount

Reply
laurena022
New 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') )
)
 
0 REPLIES 0

Helpful resources

Announcements
August Power BI Update Carousel

Power BI Monthly Update - August 2025

Check out the August 2025 Power BI update to learn about new features.

August 2025 community update carousel

Fabric Community Update - August 2025

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

Top Solution Authors