I am a Power BI PRO license user.
I have a complex measure that in MICROSOFT Service results in a bad error due to RAM overflow:
Resource Governing: The memory used by the query exceeded the configured limit. The query or calculations referenced by it might be too memory intensive. Please consider simplifying the query or calculations. If the dataset is hosted on a dedicated capacity/server, you may also reach out to your capacity/server administrator to see if the per-query memory limit can be increased. Additional information: Requested 1048577KB, Limit 1048576KB.
You can download the pbix file from here.
The page where the visual is located is the 2nd visible (Istogramma Centri - Voci).
Could someone help me optimizing the measure or telling me how solve the issue maybe in a commercial way, if the measure results to be correct?
Thanks everyone!
Giovanni 🙂
P.S. @v-juanli-msft
