Forum Discussion
Measures different in published report compared to desktop
Some measures seem to be calculating things differently in the published version of a report I have compared to what is appearing locally on desktop. The measures in the desktop version: 22.187%, -1....
I'm facing the same issue.
I've made the following collumn:
Status_Entrega =
IF('f_Owners_Monitoring'[STATUS] = "EM ANDAMENTO",
SWITCH(
TRUE(),
IF(
ISBLANK('f_Owners_Monitoring'[Previsão de conclusão pós PCP]),
('f_Owners_Monitoring'[Previsão de conclusão original] - 'f_Owners_Monitoring'[PREV_CONC_ATUAL]),
('f_Owners_Monitoring'[Previsão de conclusão pós PCP] - 'f_Owners_Monitoring'[PREV_CONC_ATUAL])) = 0, "On Track",
IF(ISBLANK('f_Owners_Monitoring'[Previsão de conclusão pós PCP]),
('f_Owners_Monitoring'[Previsão de conclusão original] - 'f_Owners_Monitoring'[PREV_CONC_ATUAL]),
('f_Owners_Monitoring'[Previsão de conclusão pós PCP] - 'f_Owners_Monitoring'[PREV_CONC_ATUAL])) > 0, "In Advance",
IF(ISBLANK('f_Owners_Monitoring'[Previsão de conclusão pós PCP]),
('f_Owners_Monitoring'[Previsão de conclusão original] - 'f_Owners_Monitoring'[PREV_CONC_ATUAL]),
('f_Owners_Monitoring'[Previsão de conclusão pós PCP] - 'f_Owners_Monitoring'[PREV_CONC_ATUAL])) < -182, "Heavily Delayed",
"Delayed"),
IF('f_Owners_Monitoring'[STATUS] = "CANCELADO", "Canceled",
"Concluded"
)
)
On PWBI desktop it works perfectly, when I publish it still calculates correctly, but when the dataset is updated, the measure doesn't return the correct value
On PWBI desktop it works perfectly, when I publish it still calculates correctly, but when the dataset is updated, the measure doesn't return the correct value
Hi guys,
I end up getting it right following the arcticle above:
https://community.powerbi.com/t5/Service/Calculated-Columns-not-updating-on-scheduled-refresh/m-p/793615
Summing all up, i've just made the calculated collumn into the Power Query, then adapted the visuals by using the new collumn.