Comparing weekly increase/ decrease of customers

[Anonymous]

Hi All,

The chart below contains a measure with the distinct count of Customers & the Legend is Product:

Current Customer Uptake =
CALCULATE(
DISTINCTCOUNT(DATA[Customer),
LASTDATE(DATA[LAST_DAY_OF_WEEK]))

Each product has a unique go live date and is used to calculate the X asis "Weeks from go live" within a custom column.

Problem:

I would like to select a particular data point in this chart and see the increase/ decrease of customers within a table format, see image below. However, when a particular data point is selected the previous weeks data disappears.

What is the best way to calculate/visualise this? Suggestions welome 🙂 

[amitchandak]

Refer to my file which uses rank to find Last week

https://www.dropbox.com/s/d9898a48e76wmvl/sales_analytics_weekWise.pbix?dl=0