Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
Solved! Go to 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.
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
@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.
Thank you @Anonymous. That makes sense, I shall have to do what I need in the query editor instead.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
111 | |
94 | |
80 | |
68 | |
59 |
User | Count |
---|---|
150 | |
119 | |
104 | |
87 | |
67 |