SummarizeColumns() using mulitple fact tables

Hi V

When I do that it returns a CROSS JOIN of the tables because it cannot propogate filter context.  Unfortunately that's not what I'm after (in my real dataset it blows the results out to about 1.2 billion rows).

I have come up with a solution through UNION, see below (I apologize for the size of the query, I don't have time right now to clean it up to match my example above).

TLDR; With the use of a simple helper column [timeEntryExists], I create the extract with the 65 [File_Numer]'s as above. I then union the results for the missing 15 [File_Number]'s (80 - 65).

EVALUATE
UNION (
    FILTER (
        SUMMARIZECOLUMNS (
            dimCase[timeEntryExists],				    // 0
            dimCase[File_Number],                                   // 1
            dimCase[File_Name],                                     // 2
            fctCase[Investigation_Type_Primary],                    // 3
            fctCase[EarliestOpeningDt],                             // 4
            fctCase[EarliestPhase],                                 // 5
            fctCase[Unit],                                          // 6
            fctCase[Unit_Team],                                     // 7
            fctCase[Outcome],                                       // 8
            fctCase[Closing_Date],                                  // 9
            tblSubject[showsect],                                   // 10
            tblSubject[SubjName],                                   // 11
            tblSubject[Settlement_Dt],                              // 12
            tblSubject[OrderFinal_Dt],                              // 13
            fctTimeManagement[Task(Clean)],                         // 14
            fctTimeManagement[Group(Clean)],                        // 15
            fctTimeManagement[Staff],                               // 16
            fctTimeManagement[JobTitle],                            // 17
            fctTimeManagement[Submitted],                           // 18
            fctTimeManagement[Date].[Year],                         // 19
            fctTimeManagement[Date].[Month],                        // 20
            "Hours", [Hours Sum]                                    // 21
        ),
        dimCase[timeEntryExists] = TRUE ()
    ),
    SELECTCOLUMNS ( // Re-arranges columns and removes [Cases] to assist with UNION appending
        FILTER (
            SUMMARIZECOLUMNS (
                dimCase[timeEntryExists],
                dimCase[File_Number],
                dimCase[File_Name],
                fctCase[Investigation_Type_Primary],
                fctCase[EarliestOpeningDt],
                fctCase[EarliestPhase],
                fctCase[Unit],
                fctCase[Unit_Team],
                fctCase[Outcome],
                fctCase[Closing_Date],
                tblSubject[showsect],
                tblSubject[SubjName],
                tblSubject[Settlement_Dt],
                tblSubject[OrderFinal_Dt],
                "Cases", [Cases]
            ),
            dimCase[timeEntryExists] = FALSE ()
        ),
        "timeEntryExists", [timeEntryExists],		            // 0
        "File_Number", [File_Number],                               // 1
        "File_Name", [File_Name],                                   // 2
        "Investigation_Type_Primary", [Investigation_Type_Primary], // 3
        "EarliestOpeningD]", [EarliestOpeningDt],                   // 4
        "EarliestPhase", [EarliestPhase],                           // 5
        "Unit", [Unit],                                             // 6
        "Unit_Team", [Unit_Team],                                   // 7
        "Outcome", [Outcome],                                       // 8
        "Closing_Date", [Closing_Date],                             // 9
        "showsect", [showsect],                                     // 10
        "SubjName", [SubjName],                                     // 11
        "Settlement_Dt", [Settlement_Dt],                           // 12
        "OrderFinal_Dt", [OrderFinal_Dt],                           // 13
        "Task(Clean)", BLANK (),                                    // 14
        "Group(Clean)", BLANK (),                                   // 15
        "Staff", BLANK (),                                          // 16
        "JobTitle", BLANK (),                                       // 17
        "Submitted", BLANK (),                                      // 18
        "Year", BLANK (),                                           // 19
        "Month", BLANK (),                                          // 20
        "Hours", BLANK ()                                           // 21
    )
)