Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Solved! Go to 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
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
After changed from ASC to DESC, it worked as I want. Many thanks Dale!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
110 | |
97 | |
78 | |
63 | |
55 |
User | Count |
---|---|
143 | |
109 | |
89 | |
84 | |
66 |