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.
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
Solved! Go to Solution.
I should have checked this previous answear before
https://community.powerbi.com/t5/Desktop/left-outer-join-using-dax-Multiple-to-Multiple/td-p/218906
I should have checked this previous answear before
https://community.powerbi.com/t5/Desktop/left-outer-join-using-dax-Multiple-to-Multiple/td-p/218906
@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 ?
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 |
---|---|
113 | |
99 | |
80 | |
70 | |
59 |
User | Count |
---|---|
149 | |
114 | |
107 | |
89 | |
67 |