Insert "number of row" column in matrix

[Anonymous]

Hello! I am in need of some serious help. I have a matrix that has one row, one column and 2 values. The matrix is sorted by"suma", descending order in totals. "suma" = sum(x) 

I want to add a column with the row number (column with red values): 

I have tried to use the RANK function as follows: 

Ranking sales = CALCULATE( RANKX(ALL( table[ITEMS]), calculate([suma]), ,desc), ALLSELECTED(table[GROUP]))

And several versions of that formula, and I get a column that does what I want when displayed in a normal table, but when I try to add it to the matrix, I can't incorporate it as a row. The only place where I can include it is as another value.

I have been told in another forum to "Add a disconnected table with the values of ranking 1 to 20 (or more if you need) this can be added using an what if parameter" but I dont know what this means..

Please help!!! 

[v-rongtiep-msft]

Hi @Anonymous ,

Please refer to my pbix file to see if it helps you.

Create a measure.

Measure = RANKX(ALLSELECTED('Table'[Item]),[suma],,DESC,Dense)

If I have misunderstood your meaning, please provide your pbix file without privacy information and desired output.

Best Regards

Community Support Team _ Polly

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

[amitchandak]

@Anonymous , try like

Ranking sales = RANKX(ALLselected( table[ITEMS]), calculate([suma],removefilters(table[GROUP])), ,desc)

[Anonymous]

hi @amitchandak , thanks for your response, unfortunately it didn't work. I still have the same problem, Power BI doesn't let me add the new measure to the matrix as a row, only as a value.

If I add the calculation you gave me as a new column, not a new measure, and incude it in the matrix, something weird happens and the whole table goups by the number 1.... very weird