Forum Discussion
Add dynamical incremental column for filtered data
Hi Anonymous ,
I will post the answer here so you can accept and hel others.
Add the following measure and change your Row Number to the code below:
ID_SUM_Group = SUMX ( MyTable, SUM ( MyTable[Index] ) )Since there can be more than one index on your context for the table visualization you need to do the following Row Code:
Row_Number = VAR Row_Number_Filter = [ID_SUM_Group] VAR temp_table = SUMMARIZE ( ALLSELECTED ( MyTable), MyTable[Column1], MyTable[Column2], MyTable[column3], ..., MyTable[ColumnN], "Row_number", [ID_SUM_Group] ) RETURN COUNTROWS ( FILTER ( temp_table, [Row_number] <= Row_Number_Filter ) )In the summarize function you need to place all the columns you have on the table visualization giving context, be aware that you may not need all of the columns so in some cases you can have a shorter summarize function since so of the columns aren't needed example if you have a ID and ID description you can only use the ID since they both relate to the same information.
Hi Anonymous ,
You need to use a technique similar to the one I used on the post below:
This is similar to your measure however I'm counting the number of rows that preceeds the value, be aware that for this type of solution you need to add the INDEX column no your visualization.
Redoing your measure should be similar to this:
Row_Number =
CALCULATE (
COUNTROWS ( MyTable ),
FILTER ( ALLSELECTED ( MyTable ), MyTable[Index] <= MAX ( MyTable[Index] ) )
)