Store fixed date in variable

[Bakhtawar]

Hi all 

i write this expression and there is not any errors in this 

vMotor_Paid = CALCULATE(SUM(Paid_excel[PAID_AMOUNT]),FILTER(Paid_excel[PAID_DATE]={[VpeDate]}))

Here I create another variable of VpeDate and store date like this "12-03-2017" (mm-dd-yyyy) 

now on KPI card when i drag this vMotor_Paid expression this shows an error 

"Calculation error in measure 'Varaibles Table'[vMotor_Paid: DAX comaprison operations do not support 

comparing values of type Date with values of type Text. Consider using the VALUE or FORMAT function to convert one of the values "

[Stachu]

try this syntax:

vMotor_Paid =
CALCULATE (
    SUM ( Paid_excel[PAID_AMOUNT] ),
    FILTER ( Paid_excel, Paid_excel[PAID_DATE] = { [VpeDate] } )
)

[Bakhtawar]

Hi when i try to add more filters this shows nothing  i tried this 

vMotor_Paid = 
CALCULATE (
    SUM ( Paid_excel[PAID_AMOUNT] ),
    FILTER ( Paid_excel, Paid_excel[PAID_DATE] = { [VpeDate] } ),
FILTER(Premium_Excel,Premium_Excel[LOB] = "MOTOR"),
FILTER(Paid_excel,Paid_excel[Flag] = "Paid"))

and in VpeDate i add date like this 

VpeDate = date(2017,12,31)