Measure is too slow

[Priya2007]

Hi ,

Below measure is bit slow:

Performance = var SAIDI_TOTAL = [SAIDI Limit]*.7

Var SAIFI_TOTAL = [SAIFI Limit]*.7

RETURN

if([CSM] <> blank(),IF([SAIDI]>[SAIDI LIMIT] || [SAIFI] > [SAIFI LIMIT],"Not Performing",

If([SAIDI]<=SAIDI_TOTAL && [SAIFI]<=SAIFI_TOTAL,"Performing",

If([SAIDI]>SAIDI_TOTAL || [SAIFI]>SAIFI_TOTAL,"Just Performing"))))

Is there a better way to do this?

[Anonymous]

Hello @Priya2007 
Please check your all measure which you're using (SAIDI LIMIT AND SAIFI LIMIT).

[m3tr01d]

Hi @Priya2007 
What is your definition of slow?
How many seconds does it take for the visual to refresh?
Also show us the definition of ALL the measures you are using. The issue might be with another measure.

Thanks

[amitchandak]

@Priya2007 , Try  like

Performance = var SAIDI_TOTAL = [SAIDI Limit]*.7
Var SAIFI_TOTAL = [SAIFI Limit]*.7
RETURN
if([CSM] <> blank() ,
Switch(True(),
[SAIDI]>[SAIDI LIMIT] || [SAIFI] > [SAIFI LIMIT],"Not Performing",
[SAIDI]<=SAIDI_TOTAL && [SAIFI]<=SAIFI_TOTAL,"Performing",
[SAIDI]>SAIDI_TOTAL || [SAIFI]>SAIFI_TOTAL,"Just Performing"))