Forum Discussion

dstiefe's avatar
dstiefe
New Member
11 years ago

Show top n entries

How can i show the top 10 items by a measure (like sales) ?
Leiterfluid's avatar
Leiterfluid
Icon for Advocate I rankAdvocate I
10 years ago

Unfortunately, using either RANKX or TOPN are overcomplicated means to solve the problem.  IWs should not have to create new measures every time they want to scope or limit a result set to limited number.

 

RANKX has proven useless for me in a situation where I have over 200,000 rows in my dimension table against a 600,000 row fact table. Even a beefy Alienware laptop with 32 GB RAM could not process the measure.

 

This should be part of not just the standard table or chart functions (as it is in excel), but would be useful in Q&A scenarios where I could type in "Top 25 cities by gross revenue" to give me a scoped result set.

 

  • HarrisMalik's avatar
    HarrisMalik
    Icon for Continued Contributor rankContinued Contributor
    10 years ago

    Leiterfluid Please support the idea here if you want to see this feature.

  • fchukoskie's avatar
    fchukoskie
    Icon for Advocate I rankAdvocate I
    10 years ago
    Leiterfluid wrote:

    ... 

    RANKX has proven useless for me in a situation where I have over 200,000 rows in my dimension table against a 600,000 row fact table. Even a beefy Alienware laptop with 32 GB RAM could not process the measure.

     

    ...

     

    For a bit, I thought maybe it was just me. Misery loves company, though. Thanks!

    • cuongle's avatar
      cuongle
      Icon for Advocate II rankAdvocate II
      10 years ago

      RANKX surely work in "Import Data" mode, but power Bi Desktop prevents to use it in "Direct Query" mode, does anyone has solution for Direct Query