Slicer by columns name

Hi Anonymous,

I would solve this using a measure do the following:

1. Create a table (do not related this with any other tables with the following structure:
   1. Name Slicer - Selection: Unity_Price, Tax_1, Tax_2, Tax_3, Tax_4
   2. 
2. Add the following measure to your data table:

3. Final_Price =
   VAR Unity_price =
       IF (
           CONTAINS ( Slicer, Slicer[Selection], "Unity_Price" ) = TRUE (),
           SUM ( Sales[Unity_Price] ),
           0
       )
   VAR Tax1 =
       IF (
           CONTAINS ( Slicer, Slicer[Selection], "Tax_1" ) = TRUE (),
           SUM ( Sales[Tax_1] ),
           0
       )
   VAR Tax2 =
       IF (
           CONTAINS ( Slicer, Slicer[Selection], "Tax_2" ) = TRUE (),
           SUM ( Sales[Tax_2] ),
           0
       )
   VAR Tax3 =
       IF (
           CONTAINS ( Slicer, Slicer[Selection], "Tax_3" ) = TRUE (),
           SUM ( Sales[Tax_3] ),
           0
       )
   VAR Tax4 =
       IF (
           CONTAINS ( Slicer, Slicer[Selection], "Tax_4" ) = TRUE (),
           SUM ( Sales[Tax_4] ),
           0
       )
   RETURN
       Unity_price + Tax1
           + Tax2
           - Tax3
           - Tax4

4. Now just add the valuies from the table you created to a slicer and your measure to the table should give the expected result:

Regards,

MFelix