Forum Discussion

maf's avatar
maf
Regular Visitor
9 years ago

Running Count

I've titled this Running Count rather than Running Total as I've seen plenty of examples that sum numerics to a given date.   I'd like to count rows to a date rather than sum values.   A good exa...
Need Help
TomMartens's avatar
TomMartens
Super User
9 years ago

Hey,

 

here is a little example

 

On the page YTD Variations you will find this measure

Cumulated Count Rows = 
CALCULATE(
 COUNTROWS('FactWithDates'),
 FILTER(
  ALL('Calendar'),
  'Calendar'[Date] <= MAX('FactWithDates'[Date]) &&
  'Calendar'[Year] = MAX('Calendar'[Year])
 )

 Here just the visible rows in the current FilterContext (introduced using CALCULATE()) are counted

 

Hope this helps

  • maf's avatar
    maf
    Regular Visitor
    9 years ago

    Appologies for my ignorance but I don't see any running count on that page.

    • TomMartens's avatar
      TomMartens
      Super User
      9 years ago

      Now it's there again, somehow I managed to not use the measure in the table viz

      • maf's avatar
        maf
        Regular Visitor
        9 years ago

        Still can't see it