I have a dashboard with a table that has a lot of fields and I use a slicer to filter the data on it that has 3 values (strings).
In the online service I get the visual exceded error in one of the value that I filter (the other two work fine).
The table that is used in the visual has the 713 rows.
If I remove "just" ine field it works perfectly.
The field I remove is buit in this manner:
Actual Planned Code Ready = CALCULATE ( VALUES ( 'public Planned Code Ready'[Planned Code Ready] ); TOPN ( 1; FILTER('public Planned Code Ready';'public Planned Code Ready'[issueid] = 'public jiraissue (2)'[id]) ; 'public Planned Code Ready'[created]; DESC ) )
The Planned Code Ready has the following info:
What can I do to improve the performance on this formula? How can I lower the memory consumption and how to debug it?
Is there any possibility that you can share me the PBIX file so that I can reproduce?
You can upload PBIX file to OneDrive and post shared link of it here.
You can send me the link through Private message.