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

It seems there have been some upload issues, please try again

maf's avatar
maf
Regular Visitor
9 years ago

I was being stupid !  Couldn't understand the numbers until I noticed that you were counting rows by year aswell, so it didn't look like I expected.  All is good now apart from when I try to apply it to my data I get..

 

"Function 'CALCULATE' is not allowed as part of calculated column DAX expressions on DirectQuery models."

 

Any ideas ?

  • v-yulgu-msft's avatar
    v-yulgu-msft
    Microsoft Employee
    9 years ago

    Hi maf,

     

    Since you were fetching data in Direct Query mode, you should create a measure rather than calculated column. The error was prompted because you created a column using above formula in Direct Query mode.

     

    Regards,
    Yuliana Gu

    • maf's avatar
      maf
      Regular Visitor
      9 years ago

      Can you explain what I should put in the messure to get the same results please ?

      • v-yulgu-msft's avatar
        v-yulgu-msft
        Microsoft Employee
        9 years ago

        Hi maf,

         

        You can refer to the DAX formula provided in TomMartens's first post.

         

        Regards,
        Yuliana Gu