HOW TO REFERENCE A MEASURE IN A FILTER

[KINENE]

Hello.

I have created a measure 

Report_Day = MAX(DATE_LT[Date])-2

I want to create measures where they reference this measure so i can just change -2 to -1 and the rest of measures work depending on the reporting date.

when i use this measure:

Day_outlet_Txns = CALCULATE(

[outlet_Dep_Txns],

FILTER(ALL(DATE_LT),[Report_Day])

)

i get a value equal to tatal transactions in a table yet i want for transactions of that report day.

When i try something else i get a error

How can i fix this error?

[tamerj1]

@KINENE 
Please use

Day_outlet_Txns =
VAR RequiredDate = [Report_Day]
RETURN
    CALCULATE (
        [Issuer_Dep_Txns],
        FILTER ( ALL ( DATE_LT ), DATE_LT[Date] = RequiredDate )
    )

[KINENE]

Hi Tamerj1,

thanx for help but when i try it out the card returns blank.

[tamerj1]

@KINENE 
Please place [Reporting Date] measure in a card. What do  you get?

[KINENE]

This is what i get

[tamerj1]

@KINENE 
Is this the correct reporting date that you want to evaluate your measure based on it?

[KINENE]

Yes, it is the correct day

[tamerj1]

@KINENE 
what is the code for [Issuer_Dep_Txns]?

[KINENE]

Issuer_Dep_Txns = COUNTROWS(ISSUER_DEPOSITS_FT)

Where ISSUER_DEPOSITS_FT is the fact table

[tamerj1]

@KINENE 
Would you please check the same date but in the fact table. Is it available in the fact table?

[KINENE]

@tamerj1 
Yes, it is available 

[tamerj1]

Hi @KINENE 

you are placing the whole date table before the "=" sign. Please use

DATE_LT[Date] = [Report_Day]