Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 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
Anonymous's avatar
Anonymous
Not applicable
3 years ago

Hi amitchandak 

am not writting any dax fun am directly using the count(distinct) in the visual.

 

  • amitchandak's avatar
    amitchandak
    Super User
    3 years ago

    Anonymous , You just used a table not SQL in the advance option of connection?

     

    Also try measure like

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

    • Anonymous's avatar
      Anonymous
      Not applicable
      3 years ago

      amitchandak 

      Yes am just using table and then in the visual,

      per a day per a vendor i need distinct count of stores so am doing like below.

       

       

      in the values i have given column and then am selecting count(distinct) like below

       

       

       

       

      • amitchandak's avatar
        amitchandak
        Super User
        3 years ago

        Anonymous , Please report an issue too -https://community.powerbi.com/t5/Issues/idb-p/Issues