topic Re: TOPN + an others Value in the same Line Chart in DAX Commands and Tips

TOPN + an others Value in the same Line Chart

Slycls — Fri, 11 Feb 2022 08:06:47 GMT

hello,

I have a problem, I want to display on a line chart a TOPN (5 lines) from a table + a value (1 line) from the same table but filter on a particular column, I don't know how take it to display the 6 lines.
Thanks for your help

Re: TOPN + an others Value in the same Line Chart

amitchandak — Fri, 11 Feb 2022 10:41:13 GMT

Slycls , refer if these can help

TOp N with Others
https://www.youtube.com/watch?v=UAnylK9bm1I
https://blog.gbrueckl.at/2019/05/power-bi-dynamic-topn-others-with-drill-down/

Re: TOPN + an others Value in the same Line Chart

Slycls — Fri, 11 Feb 2022 11:42:10 GMT

Thank you for your feedback, but this is not exactly my need.

I have a fact table and a product table (with name, brand, category, laboratory...), I would like to display in a graph the TOP 5 of all the brands and in addition the TOP 1 of the brand filter on the laboratory field. Depending on the user's choice, I always want to see the brand of a particular laboratory appear.

Re: TOPN + an others Value in the same Line Chart

tamerj1 — Sat, 12 Feb 2022 04:17:22 GMT

Hi Slycls

can you provide sample input data of let's say 10 rows. Also what do you want to see if the the Top 1 row is also part of the Top 5 rows?

Re: TOPN + an others Value in the same Line Chart

Slycls — Mon, 14 Feb 2022 07:39:49 GMT

Here is an example, I would like to display in a line graph the TOP 5 brands + the brand "Laboratoire CCD" according to the segment chosen by the user. Indeed if "CCD Laboratory" is already in the TOP 5 do not display it. Thanks for your help.

Re: TOPN + an others Value in the same Line Chart

Icey — Mon, 21 Feb 2022 09:29:08 GMT

Hi Slycls ,

Try to create two measures like so:

Rank = RANKX ( ALLSELECTED ( 'Table' ), CALCULATE ( SUM ( 'Table'[turnover] ) ), , DESC, DENSE )

Rank Filter = IF ( [Rank] <= 5 || MAX ( 'Table'[BRAND] ) = "Laboratoire CCD", 1 )

Best Regards,

Icey

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

Re: TOPN + an others Value in the same Line Chart

Slycls — Mon, 28 Feb 2022 15:41:30 GMT

Hi Icey ,

Perfect, thank you very much