Problem displaying values of a measure with Sum() Treatas()

[tahechadv_2022]

Guys,

I have the following measure:

Sum_Table2_Deactivated_Relationship_TREATAS =
    CALCULATE(
        SUM(teste_orcamento_realizado[valor_bruto])
        ,TREATAS(
            VALUES(teste_orcamento_2[ano_mes])
            ,teste_orcamento_realizado[ano_mes]
        )
    )

And that is the result on a card visual

And that is the result on a bar visual:

 

Why is there this difference in the values?

The correct is the value: 363711.18

And the other value (226505.90) is WRONG.

How can I show the right value (363711.18) in the bar graphic?

* Both columns [ano_mes] (which means [year_month]) are DATE type

* There are no additional filters

[gadielsolis]

Hello,

I would suggest check if the field "Month" you're using in the Y axis contains the dates that you have in the table "teste_orcamento_realizado". If so i would be great if you could share some screenshot of the model and the tables.

[tahechadv_2022]

the link is made between conta > conta and mes_ano > mes_ano

[Daniel29195]

is the card visual is filtered on january  same as the bar visual ? 

[tahechadv_2022]

There is no filter.

[Daniel29195]

so the value in the first image is showing the total,

however the value in the bar chart is showing the data only for january . 

so i dont think there is something wrong.

or am i missing something ?  

@tahechadv_2022 

[tahechadv_2022 · Accepted solution]

I'm sorry, the problem was data quality it wasn't a problem with the measure itself.