Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
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 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
Solved! Go to Solution.
I'm sorry, the problem was data quality it wasn't a problem with the measure itself.
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.
the link is made between conta > conta and mes_ano > mes_ano
is the card visual is filtered on january same as the bar visual ?
There is no filter.
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 ?
I'm sorry, the problem was data quality it wasn't a problem with the measure itself.
User | Count |
---|---|
83 | |
70 | |
69 | |
66 | |
53 |
User | Count |
---|---|
94 | |
92 | |
91 | |
77 | |
70 |