Any thoughts as to why the following DAX is returning TRUE for the BillingDate Column?
I do realize there is a filter applied in the variable but that’s a different column than the date. Am I misunderstanding something? There is a relationship between Sales and Billing Date on the Billing Date column. Thanks
DEFINE VAR _FilterDateRange = FILTER ( 'Billing Date', 'Billing Date'[Year] = 2019 ) EVALUATE SUMMARIZECOLUMNS ( Site[Site Code], _FilterDateRange, "Tons", 'Sales'[Invoiced Tons], "Filter", ( ISFILTERED ( 'Billing Date'[Billing Date] ) ) )