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. You can avoid iteration and improve this if you bring the SUMX expresion calculated as a Column (power query or before engine):
(FLIST[Weighted] * FLIST[GCommunityIndex])
From there you can create the measure without SUMX that is iteration a probably big table.
Regards
Happy to help!
If you're iterating a fact table, then beware of such things. You're doing a context transition on probably 100's of rows or more. Hence your problems. You should first understand well how DAX works and only then try to write measures. Good advice, mate.
Grab a book on DAX (best one but very technical is "The Ultimate Guide to DAX" by The Italians) and read upon context transition and how NOT TO WRITE DAX.
Best
Darek
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 |
---|---|
49 | |
26 | |
20 | |
15 | |
12 |
User | Count |
---|---|
57 | |
49 | |
43 | |
19 | |
18 |