Forum Discussion
Bakhtawar
Post Patron
Post PatronSum expression in dax
Hi all
I am trying to do this expression but this shows an error
expression ..
vMotor_Paid = CALCULATE(Paid_excel,SUM(Paid_excel[PAID_AMOUNT]),Paid_excel[Flag]="Paid"
,Premium_Excel[LOB]="MOTOR",Paid_excel[PAID_DATE]={[VpeDate]})
error
A function 'SUM' has been used in a True/False expression that is used as a table filter expression. This is not allowed.
in expression i am trying to do SUM OF paid_amount against filters of these
Paid_excel[Flag]="Paid",Premium_Excel[LOB]="MOTOR",Paid_excel[PAID_DATE]={[VpeDate]}here i create another varaible of VPeDate where i fixed the date "23-12-2017"any help
5 Replies
- Stachu
Community Champion
The first Paid_excel is not necessary, try this:
vMotor_Paid = CALCULATE ( SUM ( Paid_excel[PAID_AMOUNT] ), //first argument is always the expression Paid_excel[Flag] = "Paid", Premium_Excel[LOB] = "MOTOR", Paid_excel[PAID_DATE] = { [VpeDate] } )in your syntax SUM is considered a filter expression
