Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Measure optimization for fast visual rendering

Hi Guys,   I have a measure and the problem is that the associated visuals render very slow. any help will be highly appreciated. // Measure:   VAR _TopSerials = CALCULATETABLE ( TOPN ( 10...
Anonymous's avatar
Anonymous
Not applicable
3 years ago

So when I tried this measure, the visual says" there is not enough memory to complete this operation". So thi is also taking more time than the current one

tamerj1's avatar
tamerj1
Community Champion
3 years ago

Anonymous 

Fine, Please try

=
VAR _RecordDay =
    MAX ( 'fact_restarts'[RecordDay] )
VAR _TopSerials =
    TOPN (
        10,
        CALCULATETABLE (
            VALUES ( 'dim_serial_number'[serial_number] ),
            ALL ( 'dim_signature_tag1'[Tag 1] ),
            FILTER (
                VALUES ( 'fact_restarts'[RecordDay] ),
                'fact_restarts'[RecordDay] >= _RecordDay - 6
                    && 'fact_restarts'[RecordDay] <= _RecordDay
            )
        ),
        [# Restarts]
    )
RETURN
    CALCULATE (
        [# Restarts],
        EXCEPT ( VALUES ( 'dim_serial_number'[serial_number] ), _TopSerials )
    )