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...
tamerj1's avatar
tamerj1
Community Champion
3 years ago

Anonymous 

Please try

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

  • 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