topic Reference a filter in a CALCULATE DAX with reference to another field in another table in DAX Commands and Tips

Reference a filter in a CALCULATE DAX with reference to another field in another table

Anonymous — Fri, 25 Jun 2021 03:05:35 GMT

Hi,

Is there anyway i can write a CALCULATE DAX to apply the <filter> with reference to another table's selected field?

FILTER(<table>,<filter>)

In this CALCULATE DAX below, I'm trying to equate the <filter> so that it is the same as per the "Run date from another table called CURRENT_DATE". Any suggestions how this can be done?

VAR FilterTotalAmount =

CALCULATE ( [Total Amount],FILTER(MAIN_DATA,MAIN_DATA[RUN DATE]= "Run date from another table called CURRENT_DATE")

Re: Reference a filter in a CALCULATE DAX with reference to another field in another table

amitchandak — Fri, 25 Jun 2021 06:20:37 GMT

Anonymous , Try like

VAR FilterTotalAmount =

CALCULATE ( [Total Amount],FILTER(MAIN_DATA,MAIN_DATA[RUN DATE] in values(Table2[CURRENT_DATE]))

Re: Reference a filter in a CALCULATE DAX with reference to another field in another table

Anonymous — Fri, 25 Jun 2021 06:22:44 GMT

amitchandak This solution works! Thanks!