Forum Discussion
DAX Selectvalue() does not work with Dynamic Calculation Columns
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 meas...
Columns are not dynamic, they are calculated at data load so they cannot change when you change a slicer. You need a measure.
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?