Calculate sum of topN for multiple locations

[Anonymous]

Hey,

I've been looking for a solution for this topic for a while, so its time to ask this specific question myself.

To start with some background: I have 28 locations, with sub-objects. These objects have regular errors and its my job to visualise those errors. 

For this question, I want to visualise the total amount of errors for each location (which is shown in the table below). I made this based on the total of occurrences of the index.
I want to make an addition to this table which shows to sum of errors from the top 10 objects with the most errors, based on its location (Seperated version shown in the second table "Top 10 storingen", based on just 1 location). This table is made with the TopN function based on the sum of error per object.

So the crux of the matter is: 1: How can I add/calculate that total (in this case 218) to the RWZI location table?
                                             2: How can I do this cleverly for each of these locations (Preferably without making 28 measures)

I hope I made my question clear, I can always add/explain more, but I think this is the core of it all.

Thanks in advance for looking at my question.

~Gert

[Padycosmos]

Hope these videos help:

https://www.youtube.com/watch?v=y2FFjfRD-Bo

https://www.youtube.com/watch?v=inJ3Yt7ay30

[Anonymous]

@Padycosmos , Thanks you for sharing/making this measure and video. I tried it out, but it is only half of the problem (however still very usefull!).

The top 10 should be based on TagOmschrijving, but filtered for each RWZI name for I want to return the Total count of these 10 next to the overal total for each RWZI name.
So your video's do make sense, but making a TOPN measure for each of the 28 RWZI names, and then taking that TOPN total to the main table... sounds like a roundabound way to do it.
Maybe it is the only way, if so please explain how to extract that TOPN total from these 28 TOPN measures and add them to the main table.

[amitchandak]

@Anonymous , refer if this can help

Dynamic TOPN using TOPN/Window and Numeric parameter: https://youtu.be/vm2mdEioQPQ

SUMX(keepfilters(topn(10, ALL('Table'[RWZI]) , [Total Van index])), [Total Van index])

[Anonymous]

@amitchandak, Thanks you for sharing/making this measure and video. I tried it out, but it is only half of the problem (however still very usefull!).

The top 10 should be based on TagOmschrijving, but filtered for each RWZI name for I want to return the Total count of these 10 next to the overal total for each RWZI name.
So your video's do make sense, but making a TOPN measure for each of the 28 RWZI names, and then taking that TOPN total to the main table... sounds like a roundabound way to do it.
Maybe it is the only way, if so please explain how to extract that TOPN total from these 28 TOPN measures and add them to the main table.