Forum Discussion
Solved
DirectQuery COUNTA
Hello, can you please give me an advice about DirectQuery functionality? I have two tables. Table one is called Reports and second one is called Rates. Firstly I didn't need DirectQuery mode...
Hi machovamichaela,
Based on test, it’s not supported to create calculate columns with COUNTA function in “direct query” mode, however you can use this function in a measure, it works on my side.(you should turn on it first)
Turn on the option:
Measure:
Count ID = COUNTA(Table_1[ID])Regards,
Xiaoxin Sheng
Hi machovamichaela,
Based on test, it’s not supported to create calculate columns with COUNTA function in “direct query” mode, however you can use this function in a measure, it works on my side.(you should turn on it first)
Turn on the option:
Measure:
Count ID = COUNTA(Table_1[ID])
Regards,
Xiaoxin Sheng