Summary Visual from multiple columns

Hi Renee_W ,
Thank you audreygerred  very much for the solution, and I've tried other ways to help you understand the problem:

If you want to generate the visual objects you need, you can use the UNION function to regenerate a new table that may help you.

SummaryTable = 
UNION (
    SELECTCOLUMNS (
        pest_data,
        "Lifecycle", "Adult",
        "Alive", pest_data[Alive Adults],
        "Dead", pest_data[Dead Adults]
    ),
    SELECTCOLUMNS (
        pest_data,
        "Lifecycle", "Egg",
        "Alive", pest_data[Alive Eggs],
        "Dead", pest_data[Dead Eggs]
    ),
    SELECTCOLUMNS (
        pest_data,
        "Lifecycle", "Cyst",
        "Alive", pest_data[Alive Cysts],
        "Dead", pest_data[Dead Cysts]
    )
)

AliveCount = SUM('SummaryTable'[Alive])

DeadCount = SUM('SummaryTable'[Dead])

If you still have questions, I'll upload the Pbix file and hopefully help you out.

Hope it helps!

Best regards,
Community Support Team_ Tom Shen

If this post helps then please consider Accept it as the solution to help the other members find it more quickly.