cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Priya2007
Frequent Visitor

Measure is too slow

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?
3 REPLIES 3
TarunSharma
Responsive Resident
Responsive Resident

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

m3tr01d
Helper III
Helper III

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
Super User IV
Super User IV

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



Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!
Dashboard of My Blogs !! YouTube Channel !! Connect on Linkedin

Proud to be a Super User!

Helpful resources

Announcements
PBI User Groups

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group!

MBAS on Demand

Microsoft Business Applications Summit sessions

On-demand access to all the great content presented by the product teams and community members! #MSBizAppsSummit #CommunityRocks

Get Ready for Power BI Dev Camp

Power BI Dev Camp - June 24th

Mark your calendars and join us for our next Power BI Dev Camp!

Top Solution Authors
Top Kudoed Authors