topic Re: How to get a matrix row number in DAX Commands and Tips

How to get a matrix row number

Victor90 — Fri, 16 Dec 2022 20:23:11 GMT

Hello team, I have a report where I would like to count the number of rows to filter the matrix based on the amount of rows numbers, for example, from 0 - 150 k rows, from 151k - 300k rows, 301-450 rows.
I would like to create a slicer to filter the matrix depending on the selected amount.
My matrix has subcategories in rows for example
-Year
month

Year is my main row and I need to count the number of rows, is there a way to count the numbers of rows using Dax and then filter the matrix to display the information based on the amount of rows selected on the slicer?

the idea is to export by chunks os 150k rows that data to excel.

Re: How to get a matrix row number

Anonymous — Fri, 16 Dec 2022 08:23:15 GMT

Hi Victor90

Can you provide a specific sample? Then provide a result that you want .

Best Regards,
Community Support Team _ Ailsa Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Re: How to get a matrix row number

Victor90 — Fri, 16 Dec 2022 20:13:50 GMT

sure for example, here I have different rows that I can add based on a slicer selection, if I keep selecting more rows the will add dinamically

and what I want to accomplish is, to have an "index" row so I can be able to create a mesure or something that allows me to display the data by chunks, for example, create a measure that base on a slicer selection let me decide if I want to display the row from 0 - 150k rows, then from 151k - 300k rows for example, the idea to do that is to be able to export from power bi service to excel in different excel sheets and the join them.

the rows and columns are as parameters from one main table, to be able to make the matrix dynamically.

And If I create an index column of the main table it will no be able to display the info in order.

as you can see the index is not in order and I need to have from 1 to the last number.
So I am thinking if it is posible to create a column that let me iterates from 1 to n number rows and that can be modified depending on the amount of rows.