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