Forum Discussion

surfboarder1998

New Member

3 years ago

Solved

Combine Columns

I currently have a report that lists a primary and support person in two separate columns. It also lists the percent allocation for the primary person and a percent allocation for the support person ...

Need Help

barritown

3 years ago

surfboarder1998,

Then I'd flatten the initial table with the code below, rename manually "Lead Name" into just "Name" (it can be also done in [DAX] via SELECTCOLUMNS) and use this flattened table in visuals.

In plain text:

Table = 
UNION (
    SUMMARIZE ( Data, [Work Status], [Segment], [Lead Name], 
                "Role", "Lead",
                "Allocation", SUM ( Data[Lead Allocation] ) ),
    FILTER (
        SUMMARIZE ( Data, [Work Status], [Segment], [Support Name], 
                    "Role", "Support",
                    "Allocation", SUM ( Data[Support Allocation] ) ),
        NOT ISBLANK ( [Support Name] ) ) )

Best Regards,

Alexander

My YouTube vlog in English

My YouTube vlog in Russian

barritown

Solution Sage

3 years ago

surfboarder1998,

Then I'd flatten the initial table with the code below, rename manually "Lead Name" into just "Name" (it can be also done in [DAX] via SELECTCOLUMNS) and use this flattened table in visuals.

In plain text:

Table = 
UNION (
    SUMMARIZE ( Data, [Work Status], [Segment], [Lead Name], 
                "Role", "Lead",
                "Allocation", SUM ( Data[Lead Allocation] ) ),
    FILTER (
        SUMMARIZE ( Data, [Work Status], [Segment], [Support Name], 
                    "Role", "Support",
                    "Allocation", SUM ( Data[Support Allocation] ) ),
        NOT ISBLANK ( [Support Name] ) ) )

Best Regards,

Alexander

My YouTube vlog in English

My YouTube vlog in Russian