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

  • maf's avatar
    maf
    Regular Visitor
    9 years ago

    I've tried using that in a measure but get

     

    Function 'FILTER' is not supported in this context in DirectQuery mode. :(

  • TomMartens's avatar
    TomMartens
    Super User
    9 years ago

    Hey,

     

    check the following option

     

    and turn it on, please be aware, that some calculations can slow down your query performance.