Forum Discussion
Could not load visual (table) when including simple Measure
Hi all
I have a simple Measure in DAX as follows:
Measure = (SELECTEDVALUE('Table 1'[Column])) & (SELECTEDVALUE('Table 2'[Column]))
The two tables are joined with a one to many relationship, hence the need for SELECTEDVALUE. When I add this Measure to a Table in report view it loads fine, but when I include a delimiter in the function (shown below, highlighted in red) the table is no longer able to load, giving the message 'Visual has exceeded the available resources'
Measure = (SELECTEDVALUE('Table 1'[Column])) & "-" & (SELECTEDVALUE('Table 2'[Column]))
Table 1 only has 1380 rows, Table 2 has 280.
What could the problem be?
Thank you.
tgjones43 - Actually, adding the character means that the measure will never be blank. This means all rows will be included in the table visual, instead of only those with values.
3 Replies
It seems odd that a single character would produce such an error.
It is a RAM limit error, so check how much RAM is available / used while the report page is loading.
Could you share your pbix?
Cheers,
Nathan
