Removing page filter from 1 measure in illustration with multiple measures

[Anonymous]

Hi everyone 

I'm trying to create a table that shows a row with a measure that calculates index number for last seven days data and a row with a measure that calculates index number for seven days back but from yesterday. 

The index number is calculated as follows: Our revenue pr. visit / competitor revenue pr. visit

Revenue pr. visit: (# Sales / visits) * (Sales value / # sales) 

The way i got the index number for last seven days was to calcualte the measure and use a page filter that only allows last 7 days. 

This creates a problem when i need to calculate the last seven days but from yesterday. 

How do i solve this problem: 

TABLE: 

Customer	RPV Index last seven days (Today)	RPV Index last seven days (Yesterday)	Increase/decrease
Customer 1	165	131	34
Customer 2	152	165	-13
Customer 3	163	128	35
Customer 4	172	148	24
Customer 5	175	153	22
Customer 6	181	128	53
Customer 7	131	112	19
Customer 8	174	147	27

[Anonymous]

HI @Anonymous,

Can you please share your measure formulas to test? It will help to clear your scenario.

In addition, I do not so recommend you to use page-level filter to apply filter effect, it will force enabled filter effect on whole page and you can't custom which visuals interact with current filter effect.

For ignore filter effect, you can take a look at the below blog about all functions:
Managing “all” functions in DAX: ALL, ALLSELECTED, ALLNOBLANKROW, ALLEXCEPT 

Regards,

Xiaoxin Sheng

[Anonymous]

Hi @Anonymous Maybe you are right it was just super easy to use the page filter when i only need to look at 1 date interval. 

I tried the all meassure, but it did not avoid the page filter... 

How would the measures look if i need to compare the last 7 days with the last 7 days from yesterday? 🙂 

Below are the measures. 

RPV-Index = [RPV - US]/[RPV - THEM]*100

RPV - US = divide([Conversion rate % US];100)*[Avg order value US]

Conversion rate % US = DIVIDE([# Sales US ];[Visits US ])*100

Avg order value US = DIVIDE([Revenue US ];[# Sales US ])

# Sales US = sum(Sessions[Sessions with basket value US ])

Visits US= SUM(Sessions[Sessions US])

Revenue US= SUM(Sessions[Total basket value US])

RPV - THEM = divide([Conversion rate % THEM ];100)*[Avg order value THEM ]

Conversion rate % THEM = DIVIDE([# Sales THEM ];[Visits THEM ])*100

Avg order value THEM = DIVIDE([Revenue THEM ];[# Sales THEM ])

# Sales THEM = sum(Sessions[Sessions with basket value THEM ])

Visits THEM = SUM(Sessions[Sessions THEM ])

Revenue THEM = SUM(Sessions[Total basket value THEM ])