Deactivating Filtering on Subrows

[Anonymous]

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 mode, I have a slicer based on the revenue and a matrix. My matrix has two rows, customer and sales# respectively and the value of my matrix is revenue. I want this slicer only filters by customer and not by sales#. when I only have my customers and not the sales# in the matrix, this slicer is working fine and giving me what I want; however when I add sales#, the slicer is filtering based on the Sales#. Is there a way that I can deactivate the filtering for sub-rows?

I need to filter the revenue based on the customers and not the sales# but I need to keep Sales# in my matrix.

[Anonymous · Accepted solution]

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