is that for each line? or just total?
It would show on each line.
My ultimate goal is to use the result (the 11338) to filter the table so that only records with an Amounts - Source value greater than the result would show.
Yes, I do. And those filters could be changed. I’ve hard-coded the measure and the dax query for testing.
When the measure works, I want to compare it against the Amounts - Source value and return a 1 if true, 0 if false and filter for the 1s.
As the topic is marked solved. I would suggested that you open a new topic and fully explain what you exactly want with expect results
If you’re still interested, I posted a new topic and added an Excel spreadsheet that describes what I’m trying to do.