Forum Discussion

AndresEsteban's avatar
2 years ago

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

  • 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? 

    • AndresEsteban's avatar
      AndresEsteban
      Helper I

      Hi, yes, I have tried to refresh the desktop data and they are different from the ones refreshed in service