Forum Discussion

martinkoe's avatar
martinkoe
Icon for Helper I rankHelper I
5 years ago
Solved

Measure does not work when published - Year end estimate (YEE)

Hi folks,   i got a problem with a measure. It works in the desktop, but once published all tables and visuals show an error.  Tried different users, app and web based publishing, nothing works.  ...
Need Help
  • martinkoe's avatar
    martinkoe
    5 years ago

    Dear all,

     

    got it, it was an measure error. Nothing to do with gateway whatsoever.

     

    RIGHT:

    Sales PYE total = CALCULATE( [Sales YTD POS], ENDOFYEAR(DATEADD(data[Date],-1,YEAR)))
    Sales YEE = [Sales PYE total]*(1+[Sales growth rate POS])

     

    WRONG:

    Sales YEE = CALCULATE( [Sales YTD POS], ENDOFYEAR(DATEADD(data[Date],-1,YEAR),"31.12"))*(1+[Sales growth rate POS])

     

    //M

martinkoe's avatar
martinkoe
Icon for Helper I rankHelper I
5 years ago

Hi amitchandak ,

 

It is not the gateway. 

 

If i remove the particular measure of 

Sales YEE = CALCULATE( [Sales YTD POS], ENDOFYEAR(DATEADD(data[Date],-1,YEAR),"31.12"))*(1+[Sales growth rate POS])

 

everything works. Desktop & published, while the gateway is not connected.

 

So something is in this measure, which causes an error. Interestingly, in the desktop it works fine in all visualizations.

 

Any ideas?

 

Thx

//M

 

 

 

martinkoe's avatar
martinkoe
Icon for Helper I rankHelper I
5 years ago

Dear all,

 

got it, it was an measure error. Nothing to do with gateway whatsoever.

 

RIGHT:

Sales PYE total = CALCULATE( [Sales YTD POS], ENDOFYEAR(DATEADD(data[Date],-1,YEAR)))
Sales YEE = [Sales PYE total]*(1+[Sales growth rate POS])

 

WRONG:

Sales YEE = CALCULATE( [Sales YTD POS], ENDOFYEAR(DATEADD(data[Date],-1,YEAR),"31.12"))*(1+[Sales growth rate POS])

 

//M