PLACEHOLDER issue with measure in formula

[LUCASM]

I have a measure where I am trying to calculate the ASP for some products over a rolling 3 month period
This part works 
However I have now been asked to reduce the selected products only to include those products with an ASP < 200€ and here I get a PLACEHOLDER issue.
I have a calculated field called ASP_EURO which is Value/Volume
This so far works:

Avg_ASP_Rolling_3_months =

VAR XMonths = EDATE([Latest Period], -2)

VAR My_Products = CALCULATE ( DIVIDE ( SUM( [Sales Value EUR] ), Sum ( [Sales Units] ) ), Table1[Model Type] = "A", Table1[Cal_Date] >= XMonths )

RETURN My_Products

I now add the following filter ASP_EURO < 200 and it falls over

Avg_ASP_Rolling_3_months =

VAR XMonths = EDATE([Latest Period], -2)

VAR My_Products = CALCULATE ( DIVIDE ( SUM( [Sales Value EUR] ), Sum ( [Sales Units] ) ), Table1[Model Type] = "A", Table1[Cal_Date] >= XMonths, ASP_EURO < 200 )

RETURN My_Products

Why is this and what can I do to get it to work?

[LUCASM · Accepted solution]

If I add  _ASP to my dataset before it gets into my report, I can then use it as a filter like this

Avg_ASP_Rolling_3_months =

VAR XMonths = EDATE([Latest Period], -2)

VAR My_Products = CALCULATE ( 
DIVIDE ( SUM( [Sales Value EUR] ), Sum ( [Sales Units] ) ), 
Table1[Model Type] = "A", 
Table1[Cal_Date] >= XMonths, 
Table1[_ASP] < 200 )

RETURN My_Products

Not sure what the implications of doing this are, but it works

[rajendraongole1]

Hi @LUCASM - You cannot directly reference a calculated column in the filter section of a CALCULATE statement

can you try the below measure to get the asp

Avg_ASP_Rolling_3_months =
VAR XMonths = EDATE([Latest Period], -2)
VAR My_Products =
CALCULATE(
DIVIDE(
SUM( [Sales Value EUR] ),
SUM( [Sales Units] )
),
Table1[Model Type] = "A",
Table1[Cal_Date] >= XMonths,
DIVIDE( SUM( [Sales Value EUR] ), SUM( [Sales Units] ) ) < 200
)
RETURN My_Products

I hope this works.

[LUCASM]

Hi @rajendraongole1 Unfortunately that give me the following error

[rajendraongole1]

Hi @LUCASM -Calculate the rolling ASP for the product.Filter products where ASP < 200.

use below calculation:

Avg_ASP_Rolling_3_months =
VAR XMonths = EDATE([Latest Period], -2)

-- Calculate ASP for each product in the rolling 3 months
VAR My_Products =
CALCULATE (
DIVIDE ( SUM ( [Sales Value EUR] ), SUM ( [Sales Units] ) ),
Table1[Model Type] = "A",
Table1[Cal_Date] >= XMonths
)

-- Filter products where ASP < 200
VAR Filtered_Products =
CALCULATETABLE (
Table1,
My_Products < 200
)

RETURN
My_Products

[LUCASM]

Hi @rajendraongole1 
That gives me the same error message