Forum Discussion
Deactivating Filtering on Subrows
I have a table in power BI called Sales. It has 3 columns, sales#(PK), customer and revenue. Customer column is not unique, meaning each customer can have multiple sales records. Now in the report m...
HI Anonymous,
If you meant to calculate without specific filter effects from table fields, you can create a measure formula with all functions(e.g. allexcept) to ignore and respond with specific filter effect on your expression to replace raw value field.
Managing “all” functions in DAX: ALL, ALLSELECTED, ALLNOBLANKROW, ALLEXCEPT - SQLBI
Regards,
Xiaoxin Sheng
HI Anonymous,
If you meant to calculate without specific filter effects from table fields, you can create a measure formula with all functions(e.g. allexcept) to ignore and respond with specific filter effect on your expression to replace raw value field.
Managing “all” functions in DAX: ALL, ALLSELECTED, ALLNOBLANKROW, ALLEXCEPT - SQLBI
Regards,
Xiaoxin Sheng