Forum Discussion

MichaelSamiotis's avatar
MichaelSamiotis
Resolver I
3 years ago
Solved

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

Hello everyone.   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 ...
  • MichaelSamiotis's avatar
    3 years ago

    Forgot to mention that I end this formula with:

    RETURN
    COUNTROWS(FilteredSales )