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,

CALCULATETABLE (

ADDCOLUMNS (

VALUES ( 'dim_serial_number'[serial_number] ), "@Resets", [# Restarts] ),

 

FILTER ( 'fact_restarts', 'fact_restarts'[RecordDay] >= MAX ( 'fact_restarts'[RecordDay] )

- 6 && 'fact_restarts'[RecordDay] <= MAX ( 'fact_restarts'[RecordDay] ) ) ),

[@Resets] ),

ALL ( 'dim_signature_tag1'[Tag 1] ) )

 

VAR _Serials = SUMMARIZE ( _TopSerials, [serial_number] )

 

RETURN CALCULATE ( [# Restarts],

EXCEPT ( VALUES ( 'dim_serial_number'[serial_number] ), _Serials ) )

 

//

 

@Greg_Deckler  

@tamerj1 

@johnt75 

@Jihwan_Kim 

@FreemanZ 

@amitchandak 

8 Replies

  • 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

    Sadly, still not tamerj1  (:..... any other way may be??

    • Anonymous's avatar
      Anonymous
      Not applicable
      3 years ago

      HI Anonymous,

      What type of error message the visual shows? Can you please share some more detail information about this issue? They should help us clarify your scenario and test to troubleshoot.

      How to Get Your Question Answered Quickly  

      Regards,

      Xiaoxin Sheng