Forum Discussion
lawadaa
Helper I
Helper Iignore column value filter in a table visual
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- accessor...
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
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