Measure return correct value , but get syntax shown error sign , how to clear it ?

[admin11]

Hi All

Below measure working fine :-

_LYTD_REV =

var _max = date(year(today())-1,month(today()),day(today()))

return

TOTALYTD(('GL'[AMOUNT_REV]),dateadd('Date'[Date],-1,year),'Date'[Date]<=_max)

I have decide to add one more condition to above measure , SOURCE=TS :-

_LYTD_REV TDS =

var _max = date(year(today())-1,month(today()),day(today()))

return

TOTALYTD(('GL'[AMOUNT_REV]),dateadd('Date'[Date],-1,year),'Date'[Date]<=_max,

FILTER( GL, [SOURCE] = "TS" ))

Above measure return correct result , but it shown error sign , see below image :-

May i know how to clear the error ?

Below my PBI file :-

https://www.dropbox.com/s/8fzg8stsqhqensy/PBT_V2021_392%20TI_SI_GL%20REV%20measure%20shown%20error%2...

Paul Yeo

[v-janeyg-msft · Accepted solution]

Hi, @admin11 

Have your problem been solved? I checked your file, It seems that the third parameter in TOTALYTD can only write one filter, and the second will become the fourth parameter by default, causing errors, but the actual calculation will be included.

You can easily use calculate to remove red error.

Like this:

_LYTD_REV TDS =
VAR _max =
    DATE ( YEAR ( TODAY () ) - 1, MONTH ( TODAY () ), DAY ( TODAY () ) )
RETURN
    CALCULATE (
        TOTALYTD (
            ( 'GL'[AMOUNT_REV] ),
            DATEADD ( 'Date'[Date], -1, YEAR ),
            'Date'[Date] <= _max
        ),
        FILTER ( GL, [SOURCE] = "TS" )
    )

Best Regards

Janey Guo

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous]

I'm not 100% sure but you can clean it up a little by removing the Filter function. This shouldn't be needed as the TOTALYTD function is already expecting a filter here. 

LYTD_REV TDS =
VAR _max =
    DATE ( YEAR ( TODAY () ) - 1, MONTH ( TODAY () ), DAY ( TODAY () ) )
RETURN
    TOTALYTD (
        ( 'GL'[AMOUNT_REV] ),
        DATEADD ( 'Date'[Date], -1, YEAR ),
        'Date'[Date] <= _max,
        GL[SOURCE] = "TS"
    )