Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Measure output changes when published from Desktop to a premium workspace

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 workspaceVisual 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 workspaceVisual 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. 

Status: Investigating
Comments
Anonymous
Not applicable

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
Advocate II

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
Not applicable

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
Advocate II

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,