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 is in a mess. Errors show up where there were no errors previously. All my DAX generated tables fail due to errors. 

 

Works prior to refreshing:

 

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

 

- "An argument of function 'ROUND' has the wrong data type or the result is too large or too small." - this occurs to 10 DAX tables when which aggregate the main table

 

The odd thing, is previously it worked with no problems.

 

Any suggestions are very welcome

 

 

 

 

Need Help

3 Replies

  • 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?

  • v-lili6-msft's avatar
    v-lili6-msft
    Community Support
    7 years ago

    hi, Anonymous

    Could you please tell me if your problem has been solved? If it is, could you please mark the helpful replies as Answered?

     

    Best Regards,

    Lin