DAX Selectvalue() does not work with Dynamic Calculation Columns

[Ssibbett]

Hello, 

I'm new to power BI. 

I have created table "Units" that has two choices (below). This is used in a Slicer. 

Selected Units	Choice
Acre-Feet	1
Million Galons	2

I have a measure with formula: Units Value = LOOKUPVALUE(Units[Choice],Units[Select Units], SELECTEDVALUE(Units[Select Units],"Million Gallons"))

The information for the measure displays correctly on the Card. 

I have another table "Volumes" with volumes and various units for volumes. I want to allow the user to choose one unit type from "Units" table for the report display. I added a New Column to the "Volumes" table with the formula: 

Volumn UOM = SWITCH(Units[Units Value],1,[To AF]*[Volume],2,[To MG]*[Volume],0).

The report will result in the alternative "Million Gallons" dispite changes to the slicer. The Card does change values with the slicer. If I change SELECTEDVALUE(Units[Select Units],"Acre-Feet") then the report will be in "Acre-Feet". 

I have also tried using parameter for the same purpose but the results are the same. I have also tried using the formula: Units Value =  LOOKUPVALUE(Units[Choice],Units[Select Units], IF(HASONEVALUE(Units[Select Units]),VALUES(Units[Select Units]))), but that does not work. 

I believe this should work because there are some article that say so, https://spr.com/powerbi-dynamic-calculations/ 

[Greg_Deckler]

Columns are not dynamic, they are calculated at data load so they cannot change when you change a slicer. You need a measure.

[Ssibbett]

If I put the column formula in a measure, the measure will not calculate values for each row. 

Here is my column formula Volumn UOM = SWITCH(Units[Units Value],1,[To AF]*[Volume],2,[To MG]*[Volume],0).  How do I make this into a measure?