Forum Discussion

jeroenterheerdt's avatar
jeroenterheerdt
Icon for Microsoft Employee rankMicrosoft Employee
2 years ago

Share your thoughts on visual calculations (preview)

Hit "Reply" and let us know what you think of visual calculations! To learn more about this feature, please visit the blog post or our documentation.   Here are some areas that we'd like to hear ab...
General Comment
Mixednuts's avatar
Mixednuts
Icon for Helper III rankHelper III
11 months ago

Thanks for this feature. I am thoroughly enjoying it..... and it is valuable as well. 🙂

We have had one adverse issue in that in some circumstances our visuals report resource limits exceeded.

We have found that while it is possible to use a measure (already defined in the model) as part of a visual calculation formula, it can lead to the resource error.

Our workaround is to use the measure to create a separate hidden column in the visual and then use that hidden column in the calculation formula.

Thanks

  • jeroenterheerdt's avatar
    jeroenterheerdt
    Icon for Microsoft Employee rankMicrosoft Employee
    11 months ago

    hmm, can you share an example please?

    • Mixednuts's avatar
      Mixednuts
      Icon for Helper III rankHelper III
      11 months ago

      I attempted to recreate all the scenarios where resource capacity exceeded (including setting report limits and increasing the complexity of the calculation itself)

      Unfortunately had no successful failures 🙂 

      If I do evenually recreate the issue, I will re-post.

      Thanks