Visual does not work when published

[martinkoe]

Hello,

i have created a new measure and it works perfectly in the Desktop version. When i publish the Report, everything works accept this single visual. For sure it has to do with the measure, as the identical visual works with other measures (exchanged and re-published).

So the meaure works in Desktop, no failure. Published it shows an error saying "data missing", while similar measure (same data source, but different measure) does work. Tried to modify different date ranges etc. and still same failure. 

Any suggestions how i could track down the problem?

// M

[martinkoe · Accepted solution]

Dear all,

got it, it was an measure error. Nothing to do with gateway, July update 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]

Hi @Anonymous 

i was in touch with the support team, they still could not fix the problem. 

• We would like to inform you that that's a known issue and it was deployed earlier today and could you please check if it still exists or resolved for you
  • Done, Problem not resolved
• If not please try to open the Power BI service in incognito and check whether the visual is displayed or not
  • Done, Problem not resolved
• Please try to publish the report in other workspace
  • Done. Published in App and separate Workspace with separate user, Problem not resolved
• Also let us know whether the Desktop version is updated version or not
  • Done, problem not resolved.

So everything works fine in the Desktop, all values displayed. All diagrams work. Pulished there are errors in those measures which are referencing on one specific calcluation. The sources for the measure and their visualization work. 

What could be wrong with the measures of YEE??

Sales YEE = CALCULATE( [Sales PYE], ENDOFYEAR(Datum[Date],"31.12"))*(1+[Sales growth rate POS])
Sales PYE = CALCULATE(sum(invoicedetails[Umsatz (Position)]),DATESYTD(DATEADD(Datum[Date],-1,YEAR),"31.12"))
Sales growth rate POS = iferror(([Sales YTD POS]- [Sales PYTD POS])/[Sales PYTD POS],blank())

Looking forward for any feedback!

thx 

//M

[Anonymous]

Hi @martinkoe,

Can you please share some dummy data with a similar data structure and expected results? It should help us clarify your scenario and test to troubleshoot.

How to Get Your Question Answered Quickly  

Regards,

Xiaoxin Sheng

[martinkoe]

Hi @Anonymous 

got it 😁

https://www.dropbox.com/s/t0jmix2yjnfprco/Sales%20YEE_Calc.pbix?dl=0

In this Sample file it is the same case as with the full model. YEE causes an error when published, shows all visualizations in the desktop version.

THX

//M