Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

error refreshing from live database

I made a dashboard using data from a SQL database.   I set up the dashboard so that it functions perfectly well. No errors in any calculations, etc.   When I refersh my ldata, my entire dashboard...
Need Help
v-lili6-msft's avatar
v-lili6-msft
Community Support
7 years ago

HI, Anonymous

Try to make it like this ROUND(IFERROR(...,0))

Recent Scores =
SUMMARIZE (
    'Recent Score',
    'Recent Score'[LOCALE],
    "% Of 3's", ROUND (
        IFERROR (
            100
                * COUNTROWS ( FILTER ( 'Recent Score', 'Recent Score'[Score] = 3 ) )
                / COUNT ( 'Recent Score'[LOCALE] ),
            0
        ),
        1
    )
)

 

Best Regards,

Lin

 

Anonymous's avatar
Anonymous
Not applicable
6 years ago

v-lili6-msft  Hey why does wrapping this in an iferror resolve the issue?