Forum Discussion
Post ProdigyREMOVE filter from different Visual using DAX
I have a report that shows 2 visuals.
The first one displays the top 10 Sales for the current week on the article level as a matrix. There is a filter on this visual using a week offset.
The second visual shows the Sales overall (not article level) for the current year on a weekly level (axes).
The measure for Sales is a simple SUM measure : Sales = SUM(Sales[Value])
Now, I would like to click in the matrix on an article. Then the second visual should be filtered to this code.
When I do it now, just the current week is displayed in the second visual, but I need them all.
What kind of measure do I need in the second visual to display always all weeks but when selecting 1 article in the matrix this is filtered in the visual?
Adding ALL doesn't help here:
CALCULATE(SUM(Sales[Value]), ALL (Calendar))
2 Replies
- VahidDM
Super User
Hi joshua1990
Can you share a sample of your data?
BTW, try this:
CALCULATE(SUM(Sales[Value]), removefilters(Week))
If this post helps, please consider accepting it as the solution to help the other members find it more quickly.
Appreciate your Kudos!!
joshua1990VahidDM : Thanks for your support. Currently, I am not able to provide an example.
But using your approach doesn't work.
