Forum Discussion
Measure does not work when published - Year end estimate (YEE)
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
Hi amitchandak
i am a beginner, so not sure if there is a connection issue. However i am using data which is available from the source (CRM) and used in many other measure. that works. Further more, it works in desktop, but not when published (maybe i do not understand the problem with the connection).
Code error:
Aktivitäts-ID232fc515-e00c-4fea-8b48-2e7d1742be80
Anforderungs-ID36ad883c-feda-0de1-7cd1-3cf9a58b0c6b
Korrelations-IDddc33879-b478-05df-0c48-620a2ac5fe19
ZeitThu Aug 12 2021 10:33:14 GMT+0200 (Mitteleuropäische Sommerzeit)
Dienstversion13.0.16577.55
Clientversion2108.1.07152-train
Cluster-URIhttps://wabi-west-europe-b-primary-redirect.analysis.windows.net/
Hope this helps to give more accurate direction to the root cause.
Thx
//M
martinkoe , first of check this setting ui, is it asking for any details. Under datasource and credential
Looking at the error, I would advise to an issue too
Hi amitchandak
it seems to ask for a gateway, right? What does this mean. Wrong account settings?
Why did it work before June with all measures and now it does not. Sources did not changes since then, updates of the data for measures created before PowerBI July update work fine.
//M
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
