Filtered min function

[bhmiller89]

I have production data that lists sales. I need to calculate Total Sales for anything other than the original sale. Example:

I have Sale Date, Sale Amount, Client Name

I was thinking somehow I need to use

DellProduction = CALCULATE([Sales Total], 'dpmgr vwJMWebSalesOpportunitiesProduction'[CloseDate] <> MINA('dpmgr vwJMWebSalesOpportunitiesProduction'[CloseDate]))

but keep getting an error

[dkay84_PowerBI · Accepted solution]

I too don't know what you mean by "other than the original sale", but I can tell you why you are getting an error.  The filter argument for your CALCULATE function cannot compare a column with a calculated value the way you have it set up.  It needs a hard coded value and could do it this way: 'dpmgr vwJMWebSalesOpportunitiesProduction'[CloseDate] <> "12/12/2016"

Otherwise, you will need to wrap the MINA function in a VALUES function.  Additionally, you may need to wrap all this inside a FILTER function, but it is impossible to test without any sample data.

[Mi2n]

What do you mean by "anything other than the original sale". Can you provide sample data and some screenshots for better understanding your problem?