Calculate table does not work with fact table's date column

Question

Hello everyone.&nbsp;I have the below DAX formula which works perfectly but when I replace the 'Dim Dates'[Date] with 'Fact Sales'[Date] it only returns blank. I can't get why as I have a one-to-many between those two tables on the Date column.&nbsp;Test = VAR FilteredSales =&nbsp; &nbsp; DISTINCT (&nbsp; &nbsp; &nbsp; &nbsp; CALCULATETABLE (&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; SELECTCOLUMNS (&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 'Fact Sales',&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; "Column 1", [Column 1],&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; "Column 2", [Column 2],&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; "Column 3", [Column 3]&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; ),&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; LEFT (&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 'Fact Sales'[Code],&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 1&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; ) = "R",&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 'Dim Dates'[Date]&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &gt;= DATEVALUE ( "01/01/2020" ),&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 'Dim Dates'[Date]&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;= DATEVALUE ( "31/12/2020" ),&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; NOT (&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; ISBLANK ( 'Fact Sales'[Column 1] )&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; )&nbsp; &nbsp; &nbsp; &nbsp; )&nbsp; &nbsp; )&nbsp;Thank you!

michaelsamiotis · Accepted Answer

Forgot to mention that I end this formula with:RETURNCOUNTROWS(FilteredSales&nbsp;)

Forum Discussion

Calculate table does not work with fact table's date column

1 Reply

Related content

Direct Lake Model - Calculated Column/Tables

TMDL - calculated column

Table Column to Calculate Totals

Adding calculated column to date table

Lookup to unrelated table in calculated column