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 [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
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 ])

3 Replies

  • amitchandak's avatar
    amitchandak
    Super User
    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.