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 dimension tables for location where the location 2 of leg1 is location1 of leg2 and location2 of leg2 is location1 of leg3.
I can then create a table visual with the location from the 4 dimension tables as well as the average of a column in the fact tables. I would also like to add a column which is the sum of those averages. Normally I would just create a measure average(leg1[X])+average(leg2[X])+average(leg3[x]), but this runs out of memory.
It seems the issue is that when you add the average of a column into a table it is calculated diferently from a measure and that causes the memory overflow.
Is there some way to force each average to be done only within the fact table?
9 Replies
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/1447523Here 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 Shouldn't the columns in leg2 be location2 and location3 ?
