Choose a column from a table using a slicer

[paulmorgan]

I want to compare "Base Price" to any number of different Prices that are in the same table. I want the user to select which price is used.

Table

Record	Year	Base Price	Alt Price 1	Alt Price 2	Alt Price 3
1	2020	50	55	45	65
2	2021	51	56	46	66

The slicer will list Alt Price 1, Alt Price 2, Alt Price 3

I need to be able to compare Base Price vs. selected Alt Price. I want to use time-series charts and create calculated measures off of whatever Alt Price is chosen.

Suggestions on where to look are most appreciated.

[paulmorgan]

Thank you so much!

[v-yangliu-msft · Accepted solution]

Hi  @paulmorgan ,

Here are the steps you can follow：

1. Transform –  [Alt Price1], [Alt Price2], [Alt Price3] – Unpivot Columns.

2. Create measure.

Measure =
var _select=SELECTCOLUMNS('Table',"1",[Attribute])
return
SUMX(FILTER(ALL('Table'),'Table'[Attribute] in _select),[Value])

3. Result:

Best Regards,

Liu Yang

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