Column chart using mesures

alfertab Create two measures, Measure1 and Measure2 similar to the following:

Measure1 = 
  VAR __AxisValue = MAX('Table'[Axis Column])
  VAR __Result =
    SWITCH( __AxisValue,
      "Base", [Dprom Load Base],
      "Intermediate", [Dpom Net Int],
      [Dprom Net Peak]
    )
RETURN
  __Result


Measure2 = 
  VAR __AxisValue = MAX('Table'[Axis Column])
  VAR __Result =
    SWITCH( __AxisValue,
      "Base", [Dprom NET Base],
      "Intermediate", [Dpom Load Int],
      [Dprom Load Peak]
    )
RETURN
  __Result

Hi alfertab 

Thanks to Greg_Deckler  for the method, here are my additions:

A second table was created.

Measure:

Dprom Load = 
SWITCH(TRUE(),
SELECTEDVALUE('Table (2)'[a]) = "Base", [Dprom Load base],
SELECTEDVALUE('Table (2)'[a]) = "Intermediate", [Dprom Load Int],
SELECTEDVALUE('Table (2)'[a]) = "Peak", [Dprom Load peak])

Dprom Net = 
SWITCH(TRUE(),
SELECTEDVALUE('Table (2)'[a]) = "Base", [Dprom NET base],
SELECTEDVALUE('Table (2)'[a]) = "Intermediate", [Dprom Net Int],
SELECTEDVALUE('Table (2)'[a]) = "Peak", [Dprom Net peak])

Best Regards,
Yulia Xu

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