Could not load visual (table) when including simple Measure

[tgjones43]

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.

[Anonymous]

@tgjones43  -

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

[Anonymous · Accepted solution]

@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.

[tgjones43]

Thank you @Anonymous. That makes sense, I shall have to do what I need in the query editor instead.