create a measur with a filter ignoring filter on the page level

[lawadaa]

i have created a measure that calculates a oercentage with a filter. i have the same filter in my table visual but i want to ignore the filter that is in the visual and apply the filter in the measure.

example:

accessories achievement = calculate(achievement * .1 , category[type]= accessories, all(category[type))

my table visual should show the below

category	type	core achievement	accessories achievement
gross aad	core	94	8
renewal	core	90	7

 note: there's a filter on page level for the column type=core. i want to show accessories achievemnet with type= accessories ignoring this page level filter= core.

currently with the measure i created above, accessories achievement is showing blank.

[tamerj1]

Hi @lawadaa 
Assuming "Accessories" type do exist in the specified categories, please try 

Accessories Achievement =
CALCULATE (
    [Achievement] * 0.1,
    ALL ( Category ),
    VALUES ( Category[Category] ),
    Category[type] = "Accessories"
)

[ChiragGarg2512]

Interactions can be edited between the filter that is in the visual and the measure table.

[lawadaa]

the filter is in the filter pane and not in the page. interaction cant be applied as the filter is on the same column it's just that i want to filter the value in the column