Forum Discussion
Multiple Fact Table Memory Issues
Hi, I have 3 fact tables (leg1,leg2,leg3) each of which have a location1 and location2 as well as some other values that I have in slicers. I connect those tables together using 4 identical d...
Please provide sample data (with sensitive information removed) that covers your issue or question completely, in a usable format (not as a screenshot). Leave out anything not related to the issue.
If you are unsure how to do that please refer to https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-p/963216
Please show the expected outcome based on the sample data you provided.
If you want to get answers faster please refer to https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523
Here is simplified version of the data. The actual data for leg[123] has tens of thousands of rows.
leg1
location1 location2 X 1 2 1 1 3 2 2 3 3 1 2 4 2 1 5 leg2
location1 location2 X 2 1 1 2 3 2 3 2 3 1 3 4 2 3 5 leg3
location1 location2 X 1 2 1 2 3 2 3 1 3 3 2 4 2 1 5 location[ABCD]
location name 1 q 2 r 3 s Expected Results
Location A Location B Location C Location D Avg X leg1 Avg X leg2 Avg X leg3 total q r q r 2.5 1 1 4.5 q r s q 2.5 3.5 3 9 q r s r 2.5 3.5 4 10 q s r q 2 3 5 10 q s r s 2 3 2 7 r q s q 5 4 3 12 r q s r 5 4 4 13 r s r q 3 3 5 11 r s r s 3 3 2 8
