REMOVE filter from different Visual using DAX

[joshua1990]

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))

[VahidDM]

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!!

[joshua1990]

@VahidDM : Thanks for your support. Currently, I am not able to provide an example. 

But using your approach doesn't work.