Forum Discussion

Raul's avatar
Raul
Icon for Post Patron rankPost Patron
4 years ago

Optimise a SELECTEDVALUE formula

Hello community, I have a matrix visual where for each category and item 3 columns of text type and the sales amounts are shown.     Id.Item  EAN UxB Amount cat1       4.250      ...
Need Help
v-xiaotang's avatar
v-xiaotang
Icon for Community Support rankCommunity Support
4 years ago

Hi Raul 

The error occurs when a visual has attempted to query too much data for the server to complete the result with the available resources.

Try to replace SELECTEDVALUE() in your measures with MAX() or Min(), if problem is still not solved, try to filter the visual to reduce the amount of data in the result.

 

 

Best Regards,

Community Support Team _Tang

If this post helps, please consider Accept it as the solution to help the other members find it more quickly.