I have two Tables, Budget (dimension Table) and Installed Quantity (Fact Tables), linked as multiple to Multiple.
Installed Quantity is DirectQuery as it change frequently
Budget is import as it change only once a month.
to calculate Value Achieved, I am using this measure
Value Achieved=VAR _Table = FILTER ( GENERATE ( Budget_Resources, Installed_Qty ), Budget_Resources[PK] = Installed_Qty[PK] )RETURN SUMX ( _Table, [Resource Net amount/unit] * [Installed_Qty] )
when in import mode for both, it works fine, but when I changed Installed QTY to DirectQuery, it is become extremely slow, 2 minutes to render ? is there a better way
Go to Solution.
I should have checked this previous answear before
View solution in original post
@mim , are these tables not joined in the model on PK, what is the need for generating it in the measure?
If they are already joined on PK then avoid this GENERATE, if you need multiple column join use combinevalues
@amitchandak how to get a table, that containes two columns from two tables, they are linked on multiple to multiple, so I can't use related ?
Learn how to create your own user groups today!
Click here to read more about the November 2021 Updates!
Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.