Display two columns on same axis

Hi, sharc316,

Anonymous has given a good advice. Follow the steps below, you would get what you want.

1. Open Query Editor, add a conditional column as the image 1 showed. Change the type of column "IfNull" into Whole Number.

2. Choose columns "Driver #1" and "Driver #2" at the same time, and then click "Unpivot Column". You will see the result. Rename the last column to "Driver".

3. Create a measure. 

TotalMiles =
SUMX (
    Table1,
    IF ( 'Table1'[IfNull] = 1, 'Table1'[Miles] / 2, 'Table1'[Miles] )
)

It's done now. You can have a try.

Unpivoting the data does change how the data is stored.  This means you'll need to do one of two things:

1. Just check how your other visuals are set up (including any measures) and update for the new format
2. Instead of unpivoting the original table, make a copy of it in the 'Edit Queries' section, and make it a new table.  This will allow you to have visuals using the old way if you have no other option.