Forum Discussion

o59393's avatar
o59393
Icon for Post Prodigy rankPost Prodigy
3 years ago

Combine two columns into one

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.

2 Replies

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

    • o59393's avatar
      o59393
      Icon for Post Prodigy rankPost Prodigy

      Hi parry2k 

       

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


      Thanks.