Bypass Page Filter

[AaronGlenn10]

There are some other forum posts related to this subject, however still can't achieve the desired result.

I have a page that is filtered by addresses, and I'm trying to compare the year-over-year [2019 - 2020] sales % delta for those addreses to the entire state's year-over-year [2019 - 2020] sales % delta.

I"ve tried this however I'm missing somthing: 

Total TX TTM % = CALCULATE(AVERAGEX(TABC,[Same Store TTM Delta %]), (All (TABC[location_state])))

Thank you! ~AGS

[amitchandak · Accepted solution]

@AaronGlenn10 , try measures like, with a separate a table

This Year = CALCULATE(sum('order'[Qty]),filter(ALL('Date'),'Date'[Year]=max('Date'[Year])))
Last Year = CALCULATE(sum('order'[Qty]),filter(ALL('Date'),'Date'[Year]=max('Date'[Year])-1))

diff = [This Year]-[Last Year ]
diff % = divide([This Year]-[Last Year ],[Last Year ])

[AaronGlenn10]

Thank you for the reply!  I have the measures in place to calculate the YoY % Delta - just trying to bypass the page filter [160 addresses] so I can display the YoY % Delta for the entire state.

[v-robertq-msft]

Hi, @AaronGlenn10 

Glad to hear that you have solved your problem by yourself, would you like to share some experience or just mark your own reply as a solution so that others can learn from it too?

Thanks in advance!

How to Get Your Question Answered Quickly 

Best Regards,

Community Support Team _Robert Qin

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.