Forum Discussion

SBC's avatar
SBC
Helper III
1 year ago
Solved

Index Column Based on Filtered Data in Table Visual

Hi I have a table visual with three columns of data in Power BI, and I would like to add an index column that starts from 1 and increments by 1 up to the number of rows in the Name column. Specifi...
"DAX " "DAX help" 'Need help' 'DAX'
Power Query
  • Arul's avatar
    Arul
    1 year ago

    SBC ,

    try this measure,

    Index Measure = RANKX(ALLSELECTED('Sample'),CALCULATE(MAX('Sample'[Age ])),,ASC,Dense)

Arul's avatar
Arul
Super User
1 year ago

SBC ,

try this measure,

Index Measure = RANKX(ALLSELECTED('Sample'),CALCULATE(MAX('Sample'[Age ])),,ASC,Dense)