I have a table visualization in Power BI.
I am trying to get a row number added for my table.
I am using the following DAX: RANKX(table_1,table_1[customerSK],,ASC,DENSE)
I am getting the following error message:
A single value for column CustomerSK in table_1 cannot be determined. This happens when a measure formula refers to a column that contains many values without specifying an aggregation such as min, max, count...
Does anyone have any suggestions?
