Forum Discussion
o59393
Post Prodigy
3 years agoCombine 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.