Dynamic Measure Values Based on Slicer Selection with Options that are Not Connected to the Data

jmeccles

Hi, Try with this:

1. Create a calculated column in Sales Table:

SalesAmountWAdjustment =
DIVIDE (
    Sales[Sales Amount],
    LOOKUPVALUE (
        'Adjustment Rates'[Nominal Rate],
        'Adjustment Rates'[Year], Sales[Sales Year]
    )
)

2. Create a New Table --Using Enter Data

3. Insert a Slicer Visual With Options Field

4. Finally Create a Measure :

Measure =
IF (
    SELECTEDVALUE ( Options[Options] ) = "Adjusted",
    SUM ( Sales[SalesAmountWAdjustment] ),
    SUM ( Sales[Sales Amount] )
)

5. Insert this measure in a Card Visual or another that you desire.

Regards

Victor

Lima - Peru