Solved: Wrong value after refreshing on service

ThiagoDuarte · ‎12-05-2022

Hello,

My report works fine on desktop and i can update it and still get the right results, but when after publishing it, at first i get the right values but if i update the dataset via service I get wrong values afterwards

1. Desktop

2. Service (after publishing):

3. Service after refreshing (refresh on service)

My report is in premium capacity
I've tried refreshing the browser, cleaning history and cache and a few diferent browsers
I've tried deleting and republishing. It works but after refreshing on service I get the same error
I need the refresh to be fully automated (every couple hours)

Some information about the data:

There's a table called reportexperience in which there are a few columns with the lead time (for each part - there are a lot of them) for each sector of production (for each part all the information is in the same row and it has no sector id column)
Each lead time is a calculated column
There's a table with each sector and it is not related to the first one
The measure showed in the graph is as follows:

lead_medio = 
var setorid = MAX(Setor[setor_id])
return
SWITCH(TRUE(),
setorid=1,AVERAGE(reportexperience[lead_moldagem]),
setorid=2,AVERAGE(reportexperience[lead_revisão]),
setorid=3,AVERAGE(reportexperience[lead_vazamento]),
setorid=4,AVERAGE(reportexperience[lead_desmoldagem]),
setorid=5,AVERAGE(reportexperience[lead_quebra]),
setorid=6,AVERAGE(reportexperience[lead_toto]),
setorid=7,AVERAGE(reportexperience[lead_qc]),
setorid=8,AVERAGE(reportexperience[lead_eng]),
setorid=10,AVERAGE(reportexperience[lead_total])
)

I'm trying to use the sector table as a index for x axis and calculate the average lead time (based on the reportexperience table)

Does anyone know what might be happening and how to fix it?

Thanks,

Thiago Duarte