DAX Selectvalue() does not work with Dynamic Calculation Columns

Ssibbett — Mon, 09 Mar 2020 22:59:22 GMT

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/

Re: DAX Selectvalue() does not work with Dynamic Calculation Columns

Greg_Deckler — Tue, 10 Mar 2020 02:42:13 GMT

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

Re: DAX Selectvalue() does not work with Dynamic Calculation Columns

Ssibbett — Tue, 10 Mar 2020 16:05:39 GMT

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?

topic Re: DAX Selectvalue() does not work with Dynamic Calculation Columns in DAX Commands and Tips

DAX Selectvalue() does not work with Dynamic Calculation Columns

Re: DAX Selectvalue() does not work with Dynamic Calculation Columns

Re: DAX Selectvalue() does not work with Dynamic Calculation Columns