Solved: How to find Rank on 2 Columns with duplicate value... - Page 2

Anonymous · ‎12-06-2019

Hi,

I need to find a Rank on combination of 2 columns DocumentID, InoviceNumber.

See the the sample data,

Expected Result as below,

Please help me in achieveing the desired output(Rank).

A quick help would be much appreciated

v-shex-msft · ‎12-10-2019

Hi @Anonymous ,

You can add a filter on process filed(before group steps), then custom index column will be change based on filtered records.
If you mean these records need to be changes based on visual level filter/slicer, it is impossible. Current power bi not able to use them to interact with query tables records. (visual level data are generated from data model tables, data model table records are generated from query tables, you can't use child-level records to effect its parent)

Regards,

Xiaoxin Sheng

Community Support Team _ Xiaoxin
If this post helps, please consider accept as solution to help other members find it more quickly.

View solution in original post

How to find Rank on 2 Columns with duplicate values

Helpful resources

Microsoft Fabric Learn Together

Power BI Monthly Update - April 2024

Fabric Community Update - April 2024

How to Get Your Question Answered Quickly