How to filter on individual rows in a matrix tabel

[Anonymous]

Hi,

I would like to build up a financial P&L based on a multiple dimension accounting system.

The problem is that I have some Group accounts like "unit cost", which includes only some of the departments, and another Group accounts like "overheads cost" which includes these departments. 

So the question is, is it possible to put a filter on individually rows in a matrix, so that I exclude single departments when looking at unit cost, but include them again when analyzing overheads cost?

A solution is to have two different matrix, but if it is possible to do different it could be cool 🙂     

		Actuals	Budget	Varians	Year to date actuals	Year to date budget	Year to date varians
Unitcost
	Include Department x
	Include Department y
	Exclude Deparment Z
Overheads
	Include Department x
	Include Department y
	Include Deparment Z

I hope you can help 🙂 

Søren 

[v-lionel-msft · Accepted solution]

Hi  , @Anonymous 

Here's my original data:

First, I created another table:

Table = VALUES(Sheet1[Column2])

Second, create measures:

Measure = 
VAR x =
CONCATENATEX(
    ALLSELECTED('Table'[Column2]),
    'Table'[Column2],
    ","
)
VAR y = 
FIND(
    MIN(Sheet1[Column2]),
    x,
    1,
    0
)
RETURN
IF(
    MAX(Sheet1[Column1]) = "Unitcost" && y > 0,
    0, 1
)

Third, set visual level filter:

At last, you can get this:

Best regards,
Lionel Chen

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.