topic Re: Ranking and Create Group Issue in DAX Commands and Tips

Ranking and Create Group Issue

rob2 — Mon, 30 Dec 2019 17:20:24 GMT

I have a measure that ranks competitors by the number of scrapes. I am then using a disconnected table to filter only the top 5 competitors with the most scrapes. The top 5 competitors ranking is dynamic because the user can select the dates and products.

My issues is that we I use a line chart and try to create a Group on those top 5 competitors it automatically brings back all of the competitors. How can I Group only the 5 competitors?

Thanks.

Re: Ranking and Create Group Issue

JarroVGIT — Tue, 31 Dec 2019 19:00:22 GMT

Can you please post a pbix file without confidential information? Then we can have a look at what you have tried already and how your data model looks like 🙂

Kind regards

Djerro123

-------------------------------

If this answered your question, please mark it as the Solution. This also helps others to find what they are looking for.

Keep those thumbs up coming! 🙂

Re: Ranking and Create Group Issue

Anonymous — Tue, 04 Aug 2020 04:01:36 GMT

Hi rob2 ,

See if this article helps you

https://www.sqlbi.com/articles/showing-the-top-5-products-and-others-row/

Regards,
Harsh Nathani
Did I answer your question? Mark my post as a solution! Appreciate with a Kudos!! (Click the Thumbs Up Button)