Forum Discussion

surfboarder1998's avatar
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's avatar
    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