How to add one more condition to GL YTD expression

[admin11]

Hi All,

Below expression work fine :-

_YTD REV = CALCULATE(CALCULATE(GL[AMOUNT],DATESYTD('Date'[Date],"12/31")), GL[1_REV] = "REV")

I like to add SOURCE=TS into above expression , I try below :-

_YTD REV TDS = CALCULATE(CALCULATE(GL[AMOUNT],DATESYTD('Date'[Date],"12/31")), GL[1_REV] = "REV",filter(SALES,[SOURCE] = "TS"))

it Return blank.

Below is my PBI file :-

https://www.dropbox.com/s/stywxtaeu9fuv1z/PBT_V2021_392%20TI_SI_GL%20how%20to%20add%20SOURCE%3DTS%20...

Paul

[selimovd · Accepted solution]

Hey @admin11 ,

is there a reason for the double Calculate?

Try the following measure:

_YTD REV TDS =
CALCULATE(
    [AMOUNT],
    DATESYTD( 'Date'[Date], "12/31" ),
    GL[1_REV] = "REV",
    FILTER( SALES, [SOURCE] = "TS" )
)

If you need any help please let me know.

If I answered your question I would be happy if you could mark my post as a solution ✔️ and give it a thumbs up 👍

Best regards

Denis

Blog: WhatTheFact.bi

[selimovd]

Hey @admin11 ,

I think I found the error.

The measure should look like that:

_YTD REV TDS = 
CALCULATE(
    [AMOUNT],
    DATESYTD( 'Date'[Date], "12/31" ),
    GL[1_REV] = "REV",
    GL[SOURCE] = "TS"
)

But the problem is that the column GL[SOURCE] doesn't contain any values "TS". For that reason the measure is always empty.

Please let me if you need further assistance.

If you need any help please let me know.

If I answered your question I would be happy if you could mark my post as a solution ✔️ and give it a thumbs up 👍

Best regards

Denis

Blog: WhatTheFact.bi