Forum Discussion

ryan_b_fiting's avatar
ryan_b_fiting
Post Patron
6 years ago

TopN Dynamic Filter in Matrix

Hello Community -    I am in need of some help with my TopN slicer and how it interacts with a Matrix.  I have a measure that is summing my TopN sales amounts by Item which is working perfect.  But...
Need Help
Show and Tell
Tips and Tricks
Tutorial Requests
ryan_b_fiting's avatar
ryan_b_fiting
Post Patron
6 years ago

v-alq-msftthat worked, I just changed the visual control to use my measure ranther than the RANK you included.

 

Now, one last question branching off of this.....I have a trend chart by BRAND, but being I do not have Items as a dimension in the visual, it is back to summing up ALL sales rather than just TopN Item Sales.  Is there any work around for that by chance?

 

Thanks 

Ryan

  • v-alq-msft's avatar
    v-alq-msft
    Community Support
    6 years ago

    Hi, ryan_b_fiting 

     

    You may modify the 'Rank' measure as below.

     

    Rank = 
RANKX(
    CALCULATETABLE(DISTINCT('Table'[Brand]),ALLSELECTED()),
    CALCULATE(SUM('Table'[Sales]))
)

     

     

     

    Result:

     

    Best Regards

    Allan

     

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

     

    • ryan_b_fiting's avatar
      ryan_b_fiting
      Post Patron
      6 years ago

      v-alq-msft  thanks, but I get the same result as before. It does not sum up the TopN items by brand, but rather sums ALL items by brand for the specific date.  See below screen shot

      The way your TopN measure works is different from what I need (you are showing TopN overall, where I need TopN Items by Brand).  Other than that I followed your steps exactyl

      • Ashish_Mathur's avatar
        Ashish_Mathur
        Super User
        6 years ago

        Hi,

        I cannot spot any mistake in the table there.  I see the Top 4 items per brand and the total (112,164.73) seems to be the summation of only those 4 items.  What is the problem?