Create a variable in PowerBI with a filter

[Anonymous]

Hello Wonderful People

Please can someone point out the error in my syntax because PB error message for syntax is useless (or me?).  Thank you in advance.

test =

Var test =

CALCULATE(

SUM('Payment Report Template'[Payment Amount]),

FILTER('Payment Report Template','Payment Report Template'[Payment Type]="Practical Completion")

)

RETURN

[Anonymous]

Thank you for your quick response!  The syntax is now working.

[serpiva64]

Hi,

you missed to write the var after Return (test)

[Jayee · Accepted solution]

Hi @Anonymous 

After Retun need to specify variable or a calculation you want to return
check the below measure

test =

Var test =

CALCULATE(

SUM('Payment Report Template'[Payment Amount]),

FILTER('Payment Report Template','Payment Report Template'[Payment Type]="Practical Completion")

)

RETURN test

If this post helps, then please consider Accept it as the solution, Appreciate your Kudos!!

[Anonymous]

Another question:

I am trying to create a variable which contains multiple variables but the syntax contains errors that I can't tell:

GFA_test =

VAR pc_as20_test =

    CALCULATE(DISTINCTCOUNT('Weekly Report Template'[D_Code]),FILTER('Weekly Report Template', 'Weekly Report Template'[Application Stage] =" 20 Funding Agreement Signed"))

VAR pc_as21_test =

    CALCULATE(DISTINCTCOUNT('Weekly Report Template'[D_Code]),FILTER('Weekly Report Template', 'Weekly Report Template'[Application Stage] =" 21 On Site Monitoring"))

VAR pc_as22_test =

    CALCULATE(DISTINCTCOUNT('Weekly Report Template'[D_Code]),FILTER('Weekly Report Template', 'Weekly Report Template'[Application Stage] ="22 Practical Completion - Retention Period (12m)"))

VAR pc_as23_test =

CALCULATE(DISTINCTCOUNT('Weekly Report Template'[D_Code]),FILTER('Weekly Report Template','Weekly Report Template'[Application Stage] ="23 Retention Payment - Application Closed"))

[Jayee]

One question per ticket please. If you need to extend your request then please raise a new ticket.

You will get a quicker response and each volunteer solver will get the kudos they deserve.

Thank you !