Forum Discussion
Anonymous
1 year agoNot applicable
Trying to create a dynamic row number in a table visual
I need to add a Row number to one of my table visuals. I've created a unique index column in the underlying table. The index can be used to create a row number starting from Row 1. Unfortunately when...
- 1 year ago
Two points if known, can provide accurate syntax.
Use case: you are trying to get the row number based on filter selection of each row.
Assuming you have index column to identify unique row, then you can use this.
Try this:
Row_Number = CALCULATE ( COUNTROWS('Table'); FILTER ( ALLSELECTED ('Table'), 'Table'[Index] <= MAX ( 'Table'[Index]) ) )Or If not you can use all the filters that are applied to the table.
Row_Number = var _v1 = SELECTEDVALUE ( 'Table'[filterColumn1]) var _v2 = SELECTEDVALUE ( 'Table'[filterColumn2]) RETURN CALCULATE ( COUNTROWS('Table'); FILTER ( ALLSELECTED ('Table'), 'Table'[filterColumn1] <= _v1 && 'Table'[filterColumn2] = _v2 ) )Hope this helps!
Fowmy
Super User
1 year agoAnonymous
The ROWNUMBER function in DAX should work for you in this case: ROWNUMBER function (DAX) - DAX | Microsoft Learn
- Anonymous1 year agoNot applicable
I tried
Row = ROWNUMBER('Table_name') The Tabe_name is the table behind the visual. Unfortunaely it only returns the value 1 for each row.