rownumber measure in a report with table ordered by multiple columns

[alessandrosky]

Hello,

I have two joined table, and i want to create a measure/field with the rownumber of this report.

This report is ordered per multiple columns -article code asc , date desc - simply by pressing <shift> and mouse click on the header of the column.

This rownumber starts again where article code changes.

Tables come from a Filemaker data source using ODBC.

Purpose of this measure/rownumber is to get only the first row for each group ordered as above described (art. code, date), then only all rownumber = 1. 

Please could you help me? Thanks a lot 🙂

[v-shex-msft]

Hi @alessandrosky ,

Any update on this? Can you please share a pbix or some dummy data that keep the raw data structure with expected results? It should help us clarify your scenario and test to coding formula.

How to Get Your Question Answered Quickly  

Regards,

Xiaoxin Sheng

[lbendlin]

Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).

Do not include sensitive information or anything not related to the issue or question.

If you are unsure how to upload data please refer to https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-...

Please show the expected outcome based on the sample data you provided.

Want faster answers? https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447...