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 = aa.chave
WHERE
    (
        aa.ind_status = 'A'
        OR aa.ind_status = 'M'
    )
    AND (
        aa.des_procedimento :: text = ANY (
            ARRAY ['ABDOMEN AGUDO'::character varying::text, 'ABDOMEN SIMPLES- A.P.'::character varying::text, 'ADICIONAL DE INCIDÊNCIA'::character varying::text, 'ANTEBRAÇO'::character varying::text, 'ART. SACRO ILÍACAS'::character varying::text, 'ARTICULAÇÃO ACRÔMIO-CLAVICULAR'::character varying::text, 'ARTICULAÇÃO COXO-FEMURAL (CADA LADO)'::character varying::text, 'ARTICULAÇÃO ESCÁPULO-UMERAL'::character varying::text, 'ARTICULAÇÃO ESTERNO-CLAVICULAR'::character varying::text, 'ARTICULAÇÃO TIBIO-TÁRSICA'::character varying::text, 'ARTICULAÇÕES SACRO-ILÍACAS'::character varying::text, 'BACIA'::character varying::text, 'BRAÇO (ÚMERO)'::character varying::text, 'CALCÂNEO'::character varying::text, 'CAVUM: LAT - HIRTZ'::character varying::text, 'CLAVÍCULA'::character varying::text, 'CLISTER OPACO (DUPLO CONTRASTE)  '::character varying::text, 'COLUNA CERVICAL: FUNCIONAL OU DINÂMICA'::character varying::text, 'COLUNA DORSAL:  A.P. - LATERAL / OU TORACICA)'::character varying::text, 'COLUNA LOMBO SACRA COM OBLIQUAS E COM SELETIVAS PARA L5/S1      '::character varying::text, 'COLUNA LOMBO-SACRA                  '::character varying::text, 'COLUNA PARA ESCOLIOSE: P. A. - LATERAL/ OU TOTAL PARA ESCOLIOSE   '::character varying::text, 'COLUNA TORACO- LOMBAR                   '::character varying::text, 'COLUNA TOTAL OU ESCOLIOSE PANORÂMICA'::character varying::text, 'COLUNA VERTEBRAL OU COLUNA TOTAL      '::character varying::text, 'CORAÇÃO E VASOS DA BASE (RCVB): P.A. - LAT'::character varying::text, 'COSTELAS- POR HEMITORAX'::character varying::text, 'COTOVELO'::character varying::text, 'COXA'::character varying::text, 'CRÂNIO P. A. LAT'::character varying::text, 'CRÂNIO P. A. LAT- BRETTON'::character varying::text, 'ESCANOMETRIA'::character varying::text, 'ESÔFAGO '::character varying::text, 'ESTERNO'::character varying::text, 'JOELHO C/ AXIAL (CADA LADO)'::character varying::text, 'JOELHO OU RÓTULA A.P. LAT - AXIAL'::character varying::text, 'JOELHO: A.P. - LATERAL'::character varying::text, 'MAMOGRAFIA'::character varying::text, 'MÃO OU QUIRODÁCTILOS'::character varying::text, 'MÃOS E PUNHOS PARA IDADE ÓSSEA'::character varying::text, 'MAXILAR INFERIOR: P. A - OBLIQUAS'::character varying::text, 'MEMBROS INFERIORES (D/E)'::character varying::text, 'MEMBROS SUPERIORES (D/E)'::character varying::text, 'OMOPLATA OU OMBRO FUNCIONAL'::character varying::text, 'ÓRBITAS P. A. LAT OBL.- HIRTZ'::character varying::text, 'OSSOS DA FACE: M.N. -  F.N. LAT - HIRTZ'::character varying::text, 'PÉ C/ CARGA'::character varying::text, 'PÉ OU PODODÁCTILOS'::character varying::text, 'PELVE C/ CARGA'::character varying::text, 'PERNA'::character varying::text, 'PUNHO A .P. - LAT'::character varying::text, 'PUNHO A .P. - LAT - OBLIQUAS'::character varying::text, 'SACRO-COCCIX'::character varying::text, 'SEIOS DA FACE: F.N. - M.N. LAT'::character varying::text, 'SELA TURCA: P. A. LAT - BRETTON'::character varying::text, 'TORAX: P. A - LAT / arcos costais'::character varying::text, 'TORNOZELO'::character varying::text, 'TORNOZELO C/ OBLIQUAS'::character varying::text, 'TRÂNSITO INTESTINAL'::character varying::text]
        )
        OR aa.des_procedimento ILIKE '%Rx%'
        OR aa.des_procedimento ILIKE '%Raio%'
    )    
    
GROUP BY  aap.qtd_procedimento
    

 

 

This is the output:

 

I've imported this view to PBI ... and that's what I got from it.

 

 

8 Replies

  • MahyarTF's avatar
    MahyarTF
    Icon for Memorable Member rankMemorable Member

    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

      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

        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

    Do you have any idea of what could solve this?