Forum Discussion

martinkoe's avatar
martinkoe
Helper I
5 years ago
Solved

Visual does not work when published

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, a...
Need Help
  • martinkoe's avatar
    martinkoe
    5 years ago

    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's avatar
martinkoe
Helper I
5 years ago

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