How to measure rows(in visual) of a table don't count part duplicated rows

[Yi]

I searched there are several message asked how to show rows of a talble in visial. But my challenge is there are some duplicated rows not displayed in table. For example , there is  a table including Index, City, Street, Value1 and Value2 information. There are duplicated value in City and Street, but Value1 and Value2 are different. Like

Index   City    Street  Value1  Value2

1           A       123      D1        C1

2           A       123      D2        C2

3           A       456      D3        C3

4           A       456      D4       C4

5           B       131      D5        C5

I use a scatter to see the Value distribution and I also want to use a table to see how many City and Street couples when I change a filter by Value1

I have the problem to show the row number in table, it show like

RowNo  City   Street

2            A       123

4            A        456

5            B        131 

What I want is

RowNo  City  Street

1            A       123

2            A       456

3            B        131

Much appreciated any feedback and help. Thanks in advance

[v-jiascu-msft · Accepted solution]

Hi @Yi,

I would suggest you use a measure since the RowNo doesn't exist in the data table.

RowNo =
RANKX (
    ALL ( Table1[City], Table1[Street] ),
    CALCULATE ( MAX ( 'Table1'[Index] ) ),
    ,
    ASC
)

Best Regards,

Dale

[Yi]

After changed from ASC to DESC, it worked as I want. Many thanks Dale!