Combine two columns into one

[o59393]

Hi All

Is it possible to have one measure's column within another one?

For example, I have:

In this case light blue column should go within the gold one. The new measure’s total should remain the same with $17.6 and the $9.27 with a different color.

The measures are:

Total Target = 
Var Target =
CALCULATE(
    [LATAM Target],
        ALL('Type with total'))
    Return
    SWITCH(
        SELECTEDVALUE('Type with total'[Type]),
        "Total",Target,
        [LATAM Target]
)

And the other one is:

OU Target = 
Var Target =
CALCULATE(
    [Company Target],
        ALL('Type with total'))
    Return
    SWITCH(
        SELECTEDVALUE('Type with total'[Type]),
        "Total",Target,
        [Company Target]
)

Is that possible?

Thanks.

[parry2k]

@o59393 it is possible, you have to create some grouping table and then use stack bar chart using that grouping. 

[o59393]

Hi @parry2k 

Is that with group by measure? Can you please share more details.

Thanks.