Forum Discussion

Tekuii's avatar
Tekuii
Frequent Visitor
4 years ago

Diferent results from query inside Postgres SQL and Power BI

So, I have a VIEW with this query   SELECT aap.qtd_procedimento, COUNT(aap.qtd_procedimento) as soma_raio_x FROM arq_agendal aa INNER JOIN arq_agenda_procedimento aap ON aap.chave ...
Need Help
MahyarTF's avatar
MahyarTF
Icon for Memorable Member rankMemorable Member
4 years ago

Hi,

what is the data type of the original column that you did sum in your measure and also have you checked the aggregation type of the column in Tabe visual?

Appreciate your Kudos

  • Tekuii's avatar
    Tekuii
    Frequent Visitor
    3 years ago

    Hi, thanks for your support, here it is how the aggregation is at the moment

     

    And the data type is set to "Whole Number"

     

    • MahyarTF's avatar
      MahyarTF
      Icon for Memorable Member rankMemorable Member
      3 years ago

      It is weird,

      Do you see the same data in the Model panel in Power BI ?

      I mean, if the data that is shown in power bi is the same as the image you shared on your first page

      • Tekuii's avatar
        Tekuii
        Frequent Visitor
        3 years ago

        Yes, it is.