Measure output changes when published from Desktop to a premium workspace

[MoeData]

I get expected results from a measure when I am on Desktop and non-premium workspace, but when I publish on Services on premium workspaces I get different results. 

Visual below (type of visual does not matter as I have the same problem with all the visuals) shows a line which is defined as a measure. This is what I see on Desktop and on non-premium workspace:

Visual as seen on Desktop and non-premium workspace

When I publish the very same report on a premium workspace then I suddenly get this:

Visual as seen on premium workspace

Then line that I had gets somehow filtered and I get only a few dots. 

Please note that I got a bit lazy and did not refresh the huge report so the two shown screenshots in this post are from different times and that is why the values of the column chart dont match between the two for October 2022. But the point here is that behaviour of the measure that shows the line suddenly changes and it only happens when I publish on premium workspace. 

[Anonymous]

Hi @MoeData 

If you publish the report to shared capacity and Premium capacity at the same time , then compare the measure in Desktop , shared capacity and Premium capacity , does the problem you have above still occur ?

Best Regards,
Community Support Team _ Ailsa Tao

[MoeData]

Hi @Anonymous 

Yes, I have just tried it again. Results on Premium capacity dont match, while on Desktop and non-premium do match. 

Best,

[Anonymous]

Hi @MoeData 

What is your measure ? Usually, the result of measure does not vary with the capacity. If you use table visual, will the results be the same in both workspaces?

Best Regards,
Community Support Team _ Ailsa Tao

[MoeData]

Hi @Anonymous 

Type of visual does not matter; I experience the same problem with table visual. 

This is the measure currently:

Production next 6 mth R13 = 
VAR currentdate = EDATE(LASTDATE('DimDate R12'[Date]),0)
VAR previousdate = EDATE(currentdate,-12)-DAY(EDATE(currentdate,-12))+1
VAR result =
    CALCULATE(
        [Production next 6 mth],
        FILTER(
            DimDate,
            DimDate[Date] >= previousdate
                && DimDate[Date] <= currentdate
        )
    )
RETURN
    result

where:

Production next 6 mth = 
DIVIDE([Backlog next 6 mth],[Capacity next 6 mth])*6

and:

Capacity next 6 mth = 
VAR MinDate =
    MIN ( DimDate[Date] )
VAR DimVersion =
    FILTER (
        'Shared DW_DimVersion',
        'Shared DW_DimVersion'[FCStartDate] = EDATE ( MinDate, -1 )
    )
VAR Dates =
    DATESINPERIOD('DimDate'[Date],MinDate, 6, MONTH)
    //DATESBETWEEN ( DimDate[Date], MinDate, EDATE ( MinDate, 5 ) )
VAR FactCapacity =
    CALCULATETABLE ( FactCapacityForecast, DimVersion, Dates )
VAR CALC0005 =
    CALCULATE (
        SUM ( FactCapacityForecast[Value] ),
        FactCapacity,
        'Shared DW_DimAccount'[AccountNumber] = "CALC0005"
    )
VAR CALC0006 =
    CALCULATE (
        SUM ( FactCapacityForecast[Value] ),
        FactCapacity,
        'Shared DW_DimAccount'[AccountNumber] = "CALC0006"
    )
VAR CALC0008 =
    CALCULATE (
        SUM ( FactCapacityForecast[Value] ),
        FactCapacity,
        'Shared DW_DimAccount'[AccountNumber] = "CALC0008"
    )
VAR CALC0016 =
    CALCULATE (
        SUM ( FactCapacityForecast[Value] ),
        FactCapacity,
        'Shared DW_DimAccount'[AccountNumber] = "CALC0016"
    )
VAR CALC0017 =
    CALCULATE (
        SUM ( FactCapacityForecast[Value] ),
        FactCapacity,
        'Shared DW_DimAccount'[AccountNumber] = "CALC0017"
    )
RETURN
    ( CALC0008 + CALC0006 )
        *  DIVIDE ( CALC0017, CALC0016 ) 
        *  DIVIDE ( CALC0005, CALC0006 ) 

Backlog next 6 mth = 
var datadate = FIRSTDATE('DimDate'[Date])
var currentdate = EDATE(FIRSTDATE('DimDate'[Date]),1)
var nextdate = EDATE(currentdate,5)-DAY(EDATE(currentdate,5))+1

var result = 
                CALCULATE(
                       [Split Net Revenue backlog],
                        FILTER(FactOrderbacklog_MonthSplit,
                           FactOrderbacklog_MonthSplit[ListDates]>=currentdate
                        && FactOrderbacklog_MonthSplit[ListDates]<=nextdate && FactOrderbacklog_MonthSplit[DateTs]=datadate
                        )
                )
return result

and lastly:

Split Net Revenue backlog = 
DIVIDE(SUM('FactOrderbacklog_MonthSplit'[Orderbacklog_Net Month split]),1000)

Best,