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

Level up your Power BI skills this month - build one visual each week and tell better stories with data! Get started

Reply
whoopie_pie
Regular Visitor

Cumulative change by quarter using ProductX of measure?

Hello, I have a measure calculating the quarter on quarter unit price changes (call it Measure1). I now want to make another measure (Measure2) that multiplies (1+ values of Measure1) in all quarters up to the selected quarter. Sample data below:

Year-QuarterUnit Price (Measure1)Measure2 (output)
2022 Q1-1+0% = 100%
2022 Q230%(100%)*(1+30%) = 130%
2022 Q315%(100%)*(130%)*(1+15%) = 149.5%

 

Measure2 = 
// Variable for (1+Measure1) value 
VAR _n = IF(ISNUMBER('Calculations'[Unit Price]), 'Calculations'[Unit Price] + 1)

RETURN CALCULATE(PRODUCTX( 
     FILTER( ALLSELECTED('Date'[DecimalDate]), 
          'Date'[DecimalDate] <= SELECTEDVALUE('Date'[DecimalDate]) ), 
     _n) )

 

My returns Measure2 output is ridiculously large numbers. Snapshot hereI cropped out the row names but each row represents a different supplier. My data starts at 2019 Q3 so Measure 2 should equal (Unit Price + 1) for that quarter. Everything after that should be a product building off of it. But you can see some funky numbers (eg row 2).

 
1 REPLY 1
lbendlin
Super User
Super User

You can't really put SELECTEDVALUE into a CALCULATE.  Use variables instead.

 

Please provide sanitized sample data that fully covers your issue.
https://community.powerbi.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-...
Please show the expected outcome based on the sample data you provided.

https://community.powerbi.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523

Helpful resources

Announcements
April Power BI Update Carousel

Power BI Monthly Update - April 2026

Check out the April 2026 Power BI update to learn about new features.

Fabric SQL PBI Data Days

Data Days 2026 coming soon!

Sign up to receive a private message when registration opens and key events begin.

New to Fabric survey Carousel

New to Fabric Survey

If you have recently started exploring Fabric, we'd love to hear how it's going. Your feedback can help with product improvements.

Power BI DataViz World Championships carousel

Power BI DataViz World Championships - June 2026

A new Power BI DataViz World Championship is coming this June! Don't miss out on submitting your entry.