topic TopN with returns too much in DAX Commands and Tips

TopN with returns too much

Anna123456 — Thu, 23 Mar 2023 17:52:54 GMT

Hello,

When I use TopN for 2 it gives me more than 2 records back ... it gives me all the records that have one of the 2 maximum numbers. How can I restrict the output to 2? And if multiple values have the maximum number it should choose a random sample....

Example:

A: 3
B: 7

C: 7
D : 7

E: 4
-> Top 2 gives me C,D,B, E (because the 2 maximum numbers are 7 and 4) but I just want C and D (or C and B ... does not matter, but just 2).

Can you help me?

~Anna

Re: TopN with returns too much

WinterMist — Thu, 23 Mar 2023 21:47:38 GMT

Anna123456

First, put the Top 2 Numbers into a table VAR (which will return 3 rows of Number 7).

Second, get the Top 2 Letters from the table VAR in Step 1 above.

Regards,

Nathan

Re: TopN with returns too much

CNENFRNL — Fri, 24 Mar 2023 04:46:30 GMT