How to debug DAX measure that result in table

[JustDavid]

Hello,

As the subject says, am wondering if there's a way to know the result/output of a measure that resulted in a table?

For example, I have a measure below, as you can see, I have _table1.

If I want to break down the formula and see the output, from FILTER function, all the way to the AddColumns, is there a way to do it?

Thanks

MEASURE =
VAR _obj =
    SELECTEDVALUE ( 'Table'[obj code] )
VAR _cost =
    SELECTEDVALUE ( 'Table'[cost code] )
VAR _id =
    SELECTEDVALUE ( 'Table'[id] )
VAR _table1 =
    ADDCOLUMNS (
        'tbl_Tier1',
        "c1",
            SUMX (
                FILTER (
                    mirrorFactTableWithAllCostCodes,
                    [id] = EARLIER ( tbl_Tier1[T1_From] )
                        && [obj code] = _obj
                        && [cost code] = _cost
                ),
                [Column]
            ) * [T1_Alloc]
    )
VAR _table2 =
    ADDCOLUMNS (
        'tbl_Tier2',
        "c1",
            VAR _result =
                (
                    SUMX ( FILTER ( _table1, [T1_To] = EARLIER ( tbl_Tier2[T2_From] ) ), [c1] )
                        + SUMX (
                            FILTER (
                                'mirrorFactTableWithAllCostCodes',
                                [id] = EARLIER ( tbl_Tier2[T2_From] )
                                    && [obj code] = _obj
                                    && [cost code] = _cost
                            ),
                            [Column]
                        )
                ) * [T2_Alloc]
            RETURN
                IF ( ISBLANK ( _result ), 0, _result )
    )
VAR _table3 =
    ADDCOLUMNS (
        'tbl_Tier3',
        "c1",
            VAR _result =
                (
                    SUMX ( FILTER ( _table2, [T2_To] = EARLIER ( tbl_Tier3[T3_From] ) ), [c1] )
                        + SUMX (
                            FILTER (
                                'mirrorFactTableWithAllCostCodes',
                                [id] = EARLIER ( tbl_Tier3[T3_From] )
                                    && [obj code] = _obj
                                    && [cost code] = _cost
                            ),
                            [Column]
                        )
                ) * [T3_Alloc]
            RETURN
                IF ( ISBLANK ( _result ), 0, _result )
    )
RETURN
    SUMX ( FILTER ( _table3, [T3_To] = _id ), [c1] )
        + SUMX (
            FILTER (
                'mirrorFactTableWithAllCostCodes',
                [id] = _id
                    && [cost code] = _cost
                    && [obj code] = _obj
            ),
            [Column]
        )

[JustDavid]

Thank you both @quantumudit and @Fowmy. I'll have a look at both

[quantumudit]

Hello  I use DAX Query View for debugging my DAX expressions. Here is a screenshot of working with DAX Query View:

You may watch the following video to understand how to work with DAX Query View:
Unboxing DAX Query View in Power BI - Unplugged #54 

Best Regards,
Udit

If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly.
Appreciate your Kudo 👍

🚀 Let's Connect: LinkedIn || YouTube || Medium || GitHub
✨ Visit My Linktree: LinkTree

Proud to be a Super User

[Fowmy]

@JustDavid 

I use the TOCSV function which concatenates the values shows as a scaler value
Here is an example:

TOCSV ( VALUES ( 'Date'[Calendar Year Quarter] ) )

More on his function: TOCSV function (DAX) - DAX | Microsoft Learn