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

amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
5 years ago

martinkoe , Please share the error in text format. Click on one of those and check for errors.

 

I think you are using a direct query source, which has not been configured for the dataset on power bi service (if cloud connection details, if on-premise , gateway details

 

In the workspace, click on three dots of dataset and open settings and check for gateway and connection details