Smart way to switch measures (Value/Volume) for more than 10 columns

RoshanK — Wed, 31 Jan 2024 13:26:18 GMT

Hi,

My table looks like this (plus other volume related columns):

I'm aiming to have all columns switch to "Value" when a user selects it.

While one apparent solution is to create a field parameter, such as "Volume/Value Period," for each column, doing so for around 10+ columns seems not optimal.

Is there a more efficient approach you would recommend?

Thanks in advance!

Re: Smart way to switch measures (Value/Volume) for more than 10 columns

123abc — Wed, 31 Jan 2024 14:10:56 GMT

Power BI:

Create Parameter: Go to the Modeling tab and create a new parameter named "Measure Type" with two options: "Value" and "Volume".
Create Calculated Column or Measure: Use DAX to create calculated columns or measures that dynamically switch between "Value" and "Volume" based on the parameter selection. For example:

Switch(
SELECTEDVALUE('Parameter'[Measure Type]),
"Value", [Value Column],
"Volume", [Volume Column]
)

Replace [Value Column] and [Volume Column] with the appropriate column names in your data model.
Use Calculated Fields: Use the calculated columns or measures in your visualizations instead of the original columns. They will automatically adjust based on the selected measure type.

By following this approach, you can efficiently handle switching between "Value" and "Volume" for multiple columns without creating separate parameters for each column.

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

In case there is still a problem, please feel free and explain your issue in detail, It will be my pleasure to assist you in any way I can.

topic Re: Smart way to switch measures (Value/Volume) for more than 10 columns in DAX Commands and Tips

Smart way to switch measures (Value/Volume) for more than 10 columns

Re: Smart way to switch measures (Value/Volume) for more than 10 columns

Power BI: