How to insert condition into my _YTD_EXP_ expression ?

[admin11]

Hi All

I have below expression working fine.

_YTD_EXP_ = CALCULATE(CALCULATE(GL[AMOUNT_EXP_],DATESYTD('Date'[Date],"12/31")))

Above expression will display all expense.

i also i have below expression working fine , it can filter only expense for salary :-it is a column. the filter name is 1_EXP_SALARY

May i know how to insert 1_EXP_SALARY Into _YTD_EXP_ ?

My PBI sample file :-

https://www.dropbox.com/s/3j23zda3z03znxi/PBT_V2021_400%20GL_TI_12.pbix?dl=0

Paul

[v-easonf-msft · Accepted solution]

Hi, @admin11 

Sorry, I don't quite understand what you mean. In your pbix, the 1_EXP_SALARY slicer can filter _YTD_EXP_ normally. Why do you still need to insert condition into my _YTD_EXP_ expression?

Maybe you can try formula as below:

_YTD_EXP_1 =
CALCULATE (
    SUM ( GL[AMT] ) * 1,
    FILTER ( GL, GL[1_EXP] = "EXP" ),
    DATESYTD ( 'Date'[Date], "12/31" ),
    FILTER ( GL, GL[1_EXP_SALARY] = "Yes" )
)

Best Regards,
Community Support Team _ Eason

[admin11]

@v-easonf-msft 

Thank you very much it work fine now.

Paul