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!
Ashish_Mathur
Super User
1 year agoHi,
See if my solution in this file helps.
- Anonymous1 year agoNot applicable
I'm getting this error.
S. No. = ROWNUMBER(ALLSELECTED('C-Standard Revisions'),ORDERBY('c-standard Revisions'[BOOK_DATE]))