Row number in Matrix

[danning1234]

Hi,

We have a matrix and it has many rows.

We want to show this matrix into 2 parts so users dont have to scroll up and down to see all data.

So i want to add a row number to the matrix (a measureand not a calculated column, because the rows are also filtered by other columns in the matrix), and then the 1st matrix shows results from 1 to 50 rows and the 2nd matrix shows from 51 to 100 rows. The result of the row numbers should not be changed in the 2nd matrix, because there we want to just apply the measure as filter, measure result from 51 to 100, and 1 to 50 for the 1st matrix.

One thing to mention, is that, the column Region_En is from a dim table, but the BDLName is from the fact.

Filters on the matrix, are, from 2 other dim tables and the fact table.

Any idea?

Thank you!!

[Icey · Accepted solution]

Hi @danning1234 ,

Please check if this measure works in your scenario, too.

Rank = 
IF (
    [Avg] <> BLANK ()
        && HASONEFILTER ( Class[Class] ),
    RANKX (
        ALL ( Class ),
        RANKX (
            ALL ( School ),
            CALCULATE ( SELECTEDVALUE ( School[School] ) ),
            ,
            ASC,
            DENSE
        ) * 100
            + RANKX (
                ALL ( Class ),
                CALCULATE ( SELECTEDVALUE ( Class[Class] ) ),
                ,
                ASC,
                DENSE
            ),
        ,
        ASC,
        DENSE
    )
)

For more details, please check the attched .pbix file.

Best Regards,

Icey

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

[danning1234]

The solution matchs already 99% of my senario. I just change a bit to make it work for my matrix.

EXCELLENT!!

And THANK YOU!!

Danning