Forum Discussion

paulmorgan's avatar
paulmorgan
Icon for Helper II rankHelper II
3 years ago
Solved

Choose a column from a table using a slicer

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

RecordYearBase PriceAlt Price 1Alt Price 2Alt Price 3
1202050554565
2202151564666

 

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.

Need Help
Tips and Tricks
  • Anonymous's avatar
    Anonymous
    3 years ago

    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

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    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