Hi,
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] ) )
)