Measure to generate a value associated with a matrix cell?

[mrothschild]

PBIX file is here: https://drive.google.com/file/d/1j_4CrUj0fPh0xK6hnO7OZ-uIWkoP5Kdg/view?usp=sharing

I have a measure that returns the first observed year in the columns below.  The programming of that measure is:

EARLIEST_TRANSACTION_YEAR = 
        CALCULATE(
            MIN('Helivalues Transaction History'[Sale Year]),
            ALLSELECTED('Helivalues Transaction History'[Sale Year]) 
        )

2010 appears in every cell in the matrix in the lower panel.

What is the DAX so that a matrix would have $9,740,000 in every cell.  Please note I can't use MAX on those values because sometimes the starting value is less than the second or third value.  

Basically, I want the value associated with year 2010 to be output into a measure.  

Thanks for any help!

[parry2k · Accepted solution]

@mrothschild I think this the measure you are looking for:

zzzzzzzzzzPrice during Starting Sale Year = 

VAR EARLIEST_TRANSACTION_YEAR = 
        CALCULATE(
            MIN('Helivalues Transaction History'[Sale Year]),
            ALLSELECTED('Helivalues Transaction History'[Sale Year]) 
        )

VAR EARLIEST_PRICE = 
CALCULATE ( 
    [zzAverage Unit Price Current Year (weighted by Model Year Units)], 
    'Helivalues Transaction History'[Sale Year] = EARLIEST_TRANSACTION_YEAR 
) 
RETURN
   EARLIEST_PRICE

✨ Follow us on LinkedIn

Check my latest blog post The Power of Using Calculation Groups with Inactive Relationships (Part 1) (perytus.com) I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!

⚡ Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.⚡

[mrothschild]

Thanks so much.  That's perfect!

[parry2k]

@mrothschild what is $9,740,000 ? is it a sum/max/average/min??? and of what column?