Need to ,create Serial number based on selected values in slicer

[Anonymous]

Hi Team,

I need to create a dynamic serial number based on Selected values in slicer, 
In slicer im using employee id(text) and RAP is a integervalue. Please help me on this.
Here is the measure im using.
S.no =

RANKX(

    ALLSELECTED('Final Table'[Automation_ID]),  -- Rank within the selected Automation_IDs only

    CALCULATE([RPA Effort(Hrs).]),  -- Sum of SalesAmount for each Automation_ID

    ,  -- No tie-breaking expression (defaults to current context)

    DESC,  -- Order ranking in descending

    DENSE  -- Dense ranking

)

[Anonymous]

Hi Ashish
The above measure is not working, the report 

[Ashish_Mathur]

I do not know the mistake that you are committing.  It works fine in my file.

[Ritaf1983 · Accepted solution]

Hi @Anonymous 

Please provide a workable sample data and your expected result from that. It is hard to figure out what you want to achieve from the description alone.  

https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-p/963216

[Anonymous]

There are many transections under each Automation id, when I filter by Automation id, I want see a uniue ID for each transection,with the indeex rewsting to 1,2,3,and so on.

[Ashish_Mathur]

Hi,

I have solved a similar problem in the attached file.

Hope this helps.