Ranking in hierarchy matrix

[DMSJennifer]

Hello everyone,

I hope someone can help me! I've been working on this problem for far too long now, and I can't figure this out. 

I have a category [OmMonster] which has data for one or more years per category (as shown). 

I want the numbers (shown on the right) per row similar to an index number(in alphabetical order), but all I get is wrong numbers. I read somewhere that I have to make a measure with Rankx, so I made the following:

But with this measure I get the following:

Is there anyone with the solution to this problem?

Kind regards,

JenniferDMS

[lbendlin]

You want to apply an index column across different hierarchy levels?  What's the rationale for that?

Please provide sample data that covers your issue or question completely.
https://community.powerbi.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-...
Please show the expected outcome based on the sample data you provided.

https://community.powerbi.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523

[DMSJennifer]

I want to automatically fill the tables. To do that, I came up with an Idea to make an index and set the filters for the table to: Indexnumber <20. By that idea only 20 rows will appear in the matrix. We use this kind of method to export the data to PDF and print it. Its a bit out of the box thinking, since PowerBI isn't a programm for printing a report, but it's working rather fine for now. The thing with printing a report page with a lot of data, is that you cant print everyting if there is a scrollbar showing. So I made multiple pages and want to automatically select the first 20 rows for page 1, the second 20 rows for page 2, and so on. 
That is the reason I want to add an index column across differend hierarchy levels. If there are any other workarounds with automatically filling such matrices, please let me know. I came up with this, but there might be an easier solution 🙂

Kind regards,
JenniferDMS

[lbendlin · Accepted solution]

What you describe sounds a lot like paginated reports...

[DMSJennifer]

Hey,

I've looked into that and I didn't even know this existed. I think that is the solution to a lot of my problems 🙂
Thank you for the respons!

Kind regards,
JenniferDMS