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
Try to make it like this ROUND(IFERROR(...,0))
Recent Scores =
"% Of 3's", ROUND (
* COUNTROWS ( FILTER ( 'Recent Score', 'Recent Score'[Score] = 3 ) )
/ COUNT ( 'Recent Score'[LOCALE] ),
Could you please tell me if your problem has been solved? If it is, could you please mark the helpful replies as Answered?
Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.
We spoke with Power BI Super User, Greg Deckler, about his charity work
Continue your learning in our online communities.