Forum Discussion
AndresEsteban
2 years agoHelper I
Problem with calculated measures
Hello
I have a data model with the following columns and formats:
- Fecha - Date format (column 1)
- Duration min - Double precision format (column 2)
- Duration hours - Double precision format (column 3)
- Available hours - measure with integer format (column 4)
- Presence - measure with double precision format (column 5)
Both measure are the followings ones:
- Available hours:
Horas disponibles mañana = CALCULATE(DISTINCTCOUNTNOBLANK(Consulta1[Fecha])*8)
- Presence:
Presencia mañana (hora) =
var maximo_hora = DISTINCTCOUNTNOBLANK(Consulta1[Fecha])*8*DISTINCTCOUNTNOBLANK(Consulta1[label])
RETURN
IF((SUMX(FILTER(Consulta1, Consulta1[Turno]="Mañana"), Consulta1[duration_hours]))>maximo_hora, maximo_hora, (SUMX(FILTER(Consulta1, Consulta1[Turno]="Mañana"), Consulta1[duration_hours])))
All calculations in Power Bi Desktop are correct:
However, when you publish it to Power BI Service and schedule an update, at the time the update is performed the data changes:
Does anyone know why this happens and how I can solve it?
2 Replies
- audreygerredSuper User
Hello! When you publish it to service it matches what you have in desktop, then when you refersh the data it changes? Have to you tried refreshing teh desktop data so that you can see if it lines up with what is showing in service?
- AndresEstebanHelper I
Hi, yes, I have tried to refresh the desktop data and they are different from the ones refreshed in service