Measure optimization for fast visual rendering

[Anonymous]

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 

[Anonymous]

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

[Anonymous]

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

[Anonymous]

[tamerj1]

@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]

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]

@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]

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]

@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 )
    )