Top 5 + Others

Hi Muratik55 ,

 

Your [TopN+Others] is a calcualted column, right?

And please tell me if [Client - Copy.1.1] and [Pieces] are measures or columns.

For now, according to my guess, your [Pieces] and [TopN+Others] are measures.

The reason for the issue is that the same client in your table may have multiple rows, so think as follows:

Client A: 3 rows

Client B: 2 rows

And I tried to reproduced your issue.

You can modify the measure to get the right ranking numbers. Below is the measure in the screenshot.

Final result:

 

Measure = 
VAR _TABLE1= SUMMARIZE(ALL('Scheduled'),[Client],"A",[Pieces measure])
VAR _TABLE2=ADDCOLUMNS(_TABLE1,"RANKX",RANKX(_TABLE1,[A],,DESC))
VAR _RANK=SUMX(FILTER(_TABLE2,[Client]=MAX('Scheduled'[Client])),[RANKX]
)
RETURN IF(_RANK <= 5, MAX('Scheduled'[Client]), "Others")

 

If you still have questions, please let me know how your data differs from my sample data.

Measures and calculated columns are different.

 

 

                                                                                                                                                         

Best Regards,

Stephen Tao

 

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