Forum Discussion

dokat's avatar
dokat
Icon for Post Prodigy rankPost Prodigy
3 years ago

Creating index column to count rows

Hi I have a .pbix file from direct query data feeds from axure server. I created a report using four tables that are linked in the back end.   The name of the tables are  Activity Status, Group, F...
Need Help
dokat's avatar
dokat
Icon for Post Prodigy rankPost Prodigy
3 years ago

AbhinavJoshi Thank you for your response. I am connected to the server via direct query to pull the data.I dont have access or visibility to query editor.  Is there a measure i can use, rankx didnt work for me because data is coming from 4 different tables, not from same table.

 

Thanks

AbhinavJoshi's avatar
AbhinavJoshi
Icon for Responsive Resident rankResponsive Resident
3 years ago

Hi, I see the situation now. Create a new column in DAX, and enter this formula 

Index =
    COUNTROWS(
        FILTER(
            ALL('TableName'),
            'TableName'[UniqueKey] <= EARLIER('TableName'[UniqueKey])
        )
    )

  • dokat's avatar
    dokat
    Icon for Post Prodigy rankPost Prodigy
    3 years ago

    AbhinavJoshi i have four tables that are linked which table should i reference to? It gives below error message.

     

    EARLIER/EARLIEST refers to an earlier row context which doesn't exist.

    • AbhinavJoshi's avatar
      AbhinavJoshi
      Icon for Responsive Resident rankResponsive Resident
      3 years ago

      The report is based on one table or combined of two or more tables? 

       

      • dokat's avatar
        dokat
        Icon for Post Prodigy rankPost Prodigy
        3 years ago

        AbhinavJoshi Its combined of 4 tables.