Forum Discussion
joshua1990
Post Prodigy
Post ProdigyRemove 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...
Hi joshua1990
you can use
CALCULATE ( SUM (Sales[Sales]), CROSSFILTER (Sales[Sales Date], 'Calendar'[Date], NONE ))
joshua1990Post Prodigy
Post ProdigyJihwan_Kim Thanks, is there any way to solve this without an extra table?
tamerj1
Community Champion
Community ChampionHi joshua1990
you can use
CALCULATE ( SUM (Sales[Sales]), CROSSFILTER (Sales[Sales Date], 'Calendar'[Date], NONE ))