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 , i try to fill a column from three table. 100k rows per table
I use this measure , and it work , but i'm exceeding max resources ...
if(SELECTEDVALUE(main[state])="new";SELECTEDVALUE(newtable[version]);SELECTEDVALUE(oldtable[version]))
I'm not familiar with DAX but i wonder the problem is with "selectedvalue" but i don't know what else to use...
Anyone can help ?
Solved! Go to Solution.
Hi @florent-3628,
My bad. It's a measure. You may still use a measure. It could be like this.
Measure = IF ( MIN ( main[state] ) = "new"; MIN ( newtable[version] ); MIN ( oldtable[version] ) )
The formula of a Calculated Column could be like below.
Measure = IF ( main[state] = "new"; RELATED ( newtable[version] ); RELATED ( oldtable[version] ) )
Best Regards,
Hi,
MIN or MAX doesn't give the correct result ; Have a look:
Hi @florent-3628,
My bad. It's a measure. You may still use a measure. It could be like this.
Measure = IF ( MIN ( main[state] ) = "new"; MIN ( newtable[version] ); MIN ( oldtable[version] ) )
The formula of a Calculated Column could be like below.
Measure = IF ( main[state] = "new"; RELATED ( newtable[version] ); RELATED ( oldtable[version] ) )
Best Regards,
Hi, Column + related was the right way ! Thank you so much .
Now i can use a lot of tables and display 5 column like this without any problem:
Hi @florent-3628,
What are the relationships among these tables? It seems a calculated column. If so, the SELECTEDVALUE could be in the wrong place. Try this formula, please.
Column = IF ( main[state] = "new"; MIN ( newtable[version] ); MIN ( oldtable[version] ) )
Best Regards,
Dale
Not sure regarding performance but you can often use an aggregation like MIN or MAX in lieu of SELECTEDVALUE. You could give that a try to see if performance improves.
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 |
---|---|
112 | |
99 | |
73 | |
72 | |
49 |
User | Count |
---|---|
145 | |
109 | |
109 | |
90 | |
64 |