Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Solved! Go to 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
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
Hi @v-shex-msft
i was in touch with the support team, they still could not fix the problem.
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
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
Hi @v-shex-msft
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
104 | |
95 | |
80 | |
67 | |
62 |
User | Count |
---|---|
138 | |
107 | |
104 | |
82 | |
63 |