Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

count(distinct) for Direct Query

Hi, Am reading data from postgres to powerbi with direct query mode. count(distinct) is not working am pasting the error below.when i change it to import mode then its working.   Error Message: ...
Need Help
amitchandak's avatar
amitchandak
Super User
4 years ago

Anonymous , If it is dax function then

 

new measure = distinctcount(Table[Column])

 

or

 

new measure = Countrows(Summarize(Table, Table[Column]) )