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
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.

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

    In that case, if you have any fact tables create and index on that, or simply add a card on the Visualization that shows the count of your ID. 

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

      AbhinavJoshi I am still getting the same 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

        Hi, try this if earlier doesn't work for you

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