topic Re: Measure optimization for fast visual rendering in DAX Commands and Tips

Measure optimization for fast visual rendering

Anonymous — Fri, 05 May 2023 17:29:49 GMT

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

Re: Measure optimization for fast visual rendering

tamerj1 — Fri, 05 May 2023 17:55:47 GMT

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

Re: Measure optimization for fast visual rendering

Anonymous — Mon, 08 May 2023 08:48:34 GMT

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....(:

Re: Measure optimization for fast visual rendering

tamerj1 — Mon, 08 May 2023 09:28:18 GMT

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

Re: Measure optimization for fast visual rendering

Anonymous — Mon, 08 May 2023 10:25:54 GMT

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

Re: Measure optimization for fast visual rendering

tamerj1 — Mon, 08 May 2023 11:00:06 GMT

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

Re: Measure optimization for fast visual rendering

Anonymous — Mon, 08 May 2023 12:40:04 GMT

Re: Measure optimization for fast visual rendering

Anonymous — Mon, 08 May 2023 12:41:05 GMT

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

Re: Measure optimization for fast visual rendering

Anonymous — Thu, 25 May 2023 07:36:04 GMT

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