How to make my REV YTD expression can display Amount with out select year=2021 ?

[admin11]

Hi All

Below expression was given by some one , it work fine , it will display Exp YTD amount even i don't need to tick Year = 2021 :-

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

I try to modify the above for REV , it work fine , But i need to tick Year = 2021 , else it will display Blank :-

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

May i know how to make the above expression can still display REV Amount , where i don't need to tick year=2021.

Edit :- it work fine now. it is cause by some filter . ( when i try to produce the sample file to simulate the issue )

Paul Yeo

 

[v-robertq-msft]

Hi, @admin11 

Glad to hear that you have solved your problem by yourself, would you like to mark your own problem description as a solution so that others can learn from it too?

Thanks in advance!

How to Get Your Question Answered Quickly 

Best Regards,

Community Support Team _Robert Qin

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