When attempting to put together a table visual, I get an error "Couldn't load the data for this visual. There's not enough memory to complete this operation. Please try again later when there may be more memory available". My entire report is 14505 KB. I have 64 bit version of Power BI. I have also enabled max cache to 16000, disabled auto date/time detect, etc but I am still getting the error.
All data is available in 1 table 'Rap+Transactions'.
The error is caused when trying to connect below measure to column "Service Line" in a table visual.
WIP+ 2020 Top 20 = SUMX(GROUPBY('Rap+Transactions','Rap+Transactions'[Service Line],'Rap+Transactions'[Project]),[Top 20 WIP+ 2020])
I tried an alternative formula but this caused the same error:
Top 20 WIP+ 2020 =
calculate([WIP+ 2020 per project],
filter(values('Rap+Transactions'[Project]),
if(rankx(all('Rap+Transactions'[Project]), [WIP+ 2020 per project],,desc) <= 20, [WIP+ 2020 per project], blank())))
The underlying formula for WIP+ 2020 per project does work and doesn't result in the out of memory error - however, I need to add a top 20 ranking to this measure so I need to apply an additional calculation to below underlying formula:
WIP+ 2020 per project =
VAR _sumofAmount =
CALCULATE( SUM ( 'Rap+Transactions'[bedrag] ), datesbetween('Rap+Transactions'[Date], min('Rap+Transactions'[Date]), max('Rap+Transactions'[Date])))
RETURN
IF ( _sumofAmount > 0, _sumofAmount, 0 )
Output should be:
| Service Line | WIP+ 2020 Top 20 |
| A | Amount X |
| B | Amount Y |
Due to confidentiality, I can't share the entire underlying dataset. Thank you in advance for your help!
