ignore column value filter in a table visual

[lawadaa]

hello

i have visual table with below fields'

I'm trying to calculate the agent achievement which is made of

1- core achievement measue (which equals 90%* by new achiev% measure)

2- accessories achievement (which equals 10%* new achiev% measure)

3- total achievement (equals the sum of core achievement and accessories achievement)

as you can see from the table above, i managed to to calculate the first 2 parts for core achievment and accessories achievement. the problem is when i was trying to sum the two percentages it's not working. as for [category type]= 'accessories' it will show blank in core achievment measure and for [category type]='Core' it shows blank for accessories achievement.

i want to show the accessoreis achievemt '7%' instead of blank for category type ='core' so that for each core category i can sum both core and accessories achievement as below

[v-shex-msft · Accepted solution]

Hi @lawadaa,

I'd like to suggest you look at the following blog about all functions and use them in your formula to ignore the specific field filter effects. Then you can manually apply filter effect as condition to filter on your expression.

Managing “all” functions in DAX: ALL, ALLSELECTED, ALLNOBLANKROW, ALLEXCEPT - SQLBI

Regards,

Xiaoxin Sheng