Forum Discussion

jondiaphanum's avatar
jondiaphanum
Frequent Visitor
7 years ago

inconsistent data between desktop and service (calculated table and a measure)

I have defined a new table ("crecimiento") based on the following DAX expresion:

 

Crecimiento = SUMMARIZE('contratos';'contratos'[fecha].[Date];' contratos'[nomcontrato];' estructuracomercial'[filial];"CrecDiario";CALCULATE(sum('contratos'[saldoeur]);LASTDATE('contratos'[fecha].[Date])) - CALCULATE(SUM(' contratos'[saldoeur]);PREVIOUSDAY(LASTDATE(' contratos'[fecha].[Date]))))

 

And I have added a visual with some measures, in example "YTD" as

 

YTD = TOTALYTD(sum(Crecimiento[CrecDiario]);Crecimiento[Date])
 
When I see the report in PBI DESKTOP it calculates ok this measure, however, when this I publish to the report server this report, the measure is multiple by much bigger and has nothing to do with the correct result (multiplied by 1MM at least)
 
Thanks 

 

 

 

 

 

 

Need Help

2 Replies

    • jondiaphanum's avatar
      jondiaphanum
      Frequent Visitor
      7 years ago

      Thanks for the reponse,

       

      After reading the other post, I decided to change format for "date" value in the following "summarize" dax function

       

      'contratos'[fecha].[Date];

       

      but I am not sure how to change the "grouping" clause in the function so as to change [date] and use convert instead of it