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