Filtering visually but not data

Hi charlotte_emily 

Create a separate dimension table for your index column or whatever the column name of those numbers are.

Relate that to your fact table with a one-to-many relationship.

Create this measure:

Percent to All Index =
DIVIDE (
    SUM ( Data[Value] ),
    -- Numerator: Calculates the total of the [Value] column in the current filter context.
    CALCULATE (
        SUM ( Data[Value] ),
        -- Denominator: Calculates the total of the [Value] column, 
        -- but overrides the current filter context as defined below.
        REMOVEFILTERS ( 'Index' ) -- Removes any filters applied to the 'Index' table or column(s). 
        -- This ensures that the denominator represents the grand total of [Value] across all 'Index' groups.
    )
)

Use that measure and the Index column from the dimension table in your visual

Please see the attached sample pbix