Forum Discussion
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 Record Year Base Price Alt Price 1 Alt Pr...
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
Thank you so much!