Separate measure results from time dimension

[robertvdleeuw]

First off, sorry if the title doesn't accurately portray the issue; I had some trouble wording it.

I have a dataset containing sales of multiple instances of clothing stores - all under the same brand. With this, I'm trying to create a page that displays the best and worst stores - revenue wise. This page has controls for the amount of top and bottom stores to display (top left) and the timeframe for the comparision (because e.g. the best and worst stores of 2018 aren't necessarily the best and worst of 2019). 

I get the top and bottom N using 2 RANKX's, one ascending and another descending:

 
Using those and the 'N input' (top left of the report), I wrap/filter the measure 'total revenue':

The problem - as you may have already been able to tell - is with the line graph in the bottom left in the report. As stated before, because the best/worst stores change over time, I need the time element to be taken into account for this calculation. But I want that linechart to display the revenue of the best and worst store(s) listed in the matrix on the right (in this case, 'Diezerstraat 80' and 'Rue des trois Cailloux 42'). But because the best and worst stores change over time, it displays the best and worst store(s) at every month, creating the mess we see right now.

Is there a way to save addresses shown in the matrix (Diezer and Rue des Trois) to then display only their 'revenue lines'?

If any other information in necessary, please tell me through I reply and I will supply it. Thanks in advance.

[v-yadongf-msft]

Hi @robertvdleeuw ,

Can you share with me some screenshots of your data after hiding sensitive information and tell me what's your expected output?

Thanks for your efforts & time in advance.

Best regards,

Yadong Fang

[robertvdleeuw]

Hey Yadong,

Sure, this is essentially what I want: a chart showing the revenue of the top/bottom stores displayed in the matrix on the right. (This example was created manually using a slicer.) (RDTC might look wrong, but only has sales on the last days of December.)

Luckily, this is a school exercise, and so I don't have to hide my data. Here's my data model. I've marked the calculated table with a red bar on the bottom.

Here are some snippets of the tables of importance to this question:
SalesTransaction (AmountGC is the paid amount that gets us the revenue.)

Stores

If you need anything else, just let me know.