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

Many thanks but Unfortunately not!  (: as it is even more slower than old one. The old one took 62290 ms and this one did not stop rendering so that i could record performance....(:

tamerj1's avatar
tamerj1
Community Champion
3 years ago

Anonymous 

Ok, please try

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