Forum Discussion

AaronGlenn10's avatar
AaronGlenn10
Helper III
5 years ago
Solved

Bypass Page Filter

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...
Need Help
  • amitchandak's avatar
    amitchandak
    5 years ago

    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's avatar
AaronGlenn10
Helper III
5 years ago

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's avatar
v-robertq-msft
Community Support
5 years ago

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.