Forum Discussion

joshua1990's avatar
joshua1990
Icon for Post Prodigy rankPost 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...
Need Help
  • tamerj1's avatar
    tamerj1
    4 years ago

    Hi joshua1990 

    you can use

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

Jihwan_Kim's avatar
Jihwan_Kim
Icon for Super User rankSuper User
4 years ago

Hi,

I am not sure if I understood your question correctly, but please check the below picture and the attached pbix file.

One of ways to create a model that a slicer does not affect the measure is to create a disconnected table and use the column from the disconnected table as a slicer.

 

 

 

  • joshua1990's avatar
    joshua1990
    Icon for Post Prodigy rankPost Prodigy
    4 years ago

    Jihwan_Kim Thanks, is there any way to solve this without an extra table?

    • tamerj1's avatar
      tamerj1
      Icon for Community Champion rankCommunity Champion
      4 years ago

      Hi joshua1990 

      you can use

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