Forum Discussion
Create a variable in PowerBI with a filter
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( S...
Hi Anonymous
After Retun need to specify variable or a calculation you want to return
check the below measuretest =
Var test =
CALCULATE(
SUM('Payment Report Template'[Payment Amount]),
FILTER('Payment Report Template','Payment Report Template'[Payment Type]="Practical Completion")
)
RETURN testIf this post helps, then please consider Accept it as the solution, Appreciate your Kudos!!
Hi,
you missed to write the var after Return (test)