Forum Discussion

joshua1990's avatar
joshua1990
Post Prodigy
4 years ago
Solved

Remove Filter to Calendar

Hi all! I have a sales table that is linked by [Sales Date] to the calendar table. Now I have a report with a month slicer to filter a matrix that shows budget vs sales. This visual shows budget v...
  • tamerj1's avatar
    tamerj1
    4 years ago

    Hi joshua1990 

    you can use

    CALCULATE ( SUM (Sales[Sales]), CROSSFILTER (Sales[Sales Date], 'Calendar'[Date], NONE ))