Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
I have a report that runs against an SSAS tabular (2019 Standard). It includes measures defined in the report. I have gotten the DAX query and run the query against our development and production server and get different results on two measures (the second depends on the first, so I will only discuss the first).
The first measure is [YTD Growth] which subtracts [YTD Sales]-[PY YTD Sales] (Year to date sales and prior year YTD sales). The query shows both [YTD Sales] and PY YTD Sales] and the values match. Since it is early in the year, one or both values are blank.
[YTD Sales] is defined in the SSAS model and is defined TOTALYTD('Sales'[Sales],'Date'[Date])
[PY YTD Sales] is defined in the report and is defined CALCULATE([YTD Sales],SAMEPERIODLASTYEAR('Date'[Date])
On development [YTD Growth] is blank, on production, [YTD Growth] has the expected value (treating blank as zero if YTD Sales or PY YTD Sales has a value and blank if both are blank).
What should I look for to account for this discrepency?
Development is version 15.0.32.62 and production is version 15.0.35.51.
Solved! Go to Solution.
I ran an update on the development SQL Server to bring it up to date. The issue no longer occurs.
My thought is that for the particular version of SSAS I was using it was not handling the transition from in model measures to in report measures (sorry, I don't know the proper terms.)
Just a little additional information.
The following query evaluates to 1 on Development and Production.
EVALUATE {1 + BLANK()}
I ran an update on the development SQL Server to bring it up to date. The issue no longer occurs.
My thought is that for the particular version of SSAS I was using it was not handling the transition from in model measures to in report measures (sorry, I don't know the proper terms.)
User | Count |
---|---|
25 | |
12 | |
8 | |
6 | |
6 |
User | Count |
---|---|
26 | |
12 | |
11 | |
10 | |
6 |