Forum Discussion
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 vs sales for each article
But now I would like to show the sales regardles of the slicer.
How can I disable the month filter in the Sales Measure?
Something like CALCULATE ( SUM (Sales[Sales]), ALL(Sales])) is not working.
Hi joshua1990
you can use
CALCULATE ( SUM (Sales[Sales]), CROSSFILTER (Sales[Sales Date], 'Calendar'[Date], NONE ))
5 Replies
- Jihwan_Kim
Super User
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.
joshua1990Jihwan_Kim Thanks, is there any way to solve this without an extra table?
- tamerj1
Community Champion
Hi joshua1990
you can use
CALCULATE ( SUM (Sales[Sales]), CROSSFILTER (Sales[Sales Date], 'Calendar'[Date], NONE ))
Hi joshua1990 you can try CALCULATE (SUM(Sales[sales], ALLEXCEPT(Sales,Sales[article])).
Hope the above works. Please feel free to suggest corrections if any.Hi joshua1990 ,
Do you want the slicer to filter only on a specific column? According to your description, you want the month slicer to filter only budget, not sales.
Unfortunately, since the slicer is related to table visual, it is not possible to still show all rows when you have selected an item in slicer. Unless you disable the interaction between slicer and visual.
To workaround your requirement, you could create an unrelated table, as mentioned by Jihwan_Kim . You will get the result as shown below. The month slicer only filters budget, not sales.
However, if you want to get the result shown above without creating an unrelated table, there is no better way so far.
Best Regards
