filtered and not filtered values in the same table when filtered

[skills29]

Hello guys, could someone help me. I have a matrix which contains NameProject in rows, Month/Year in Columns and a column name Status from f_status_projects table as shown below:

When i use a slicer visual to filter this matrix by status, for example Suspended:

However, I want it to keep appearing the name of the other status that are not suspended when one of the columns has a suspended status, and when there is no suspended status, it doesn't appear as it already does. So, i want the matrix be like this when filter Suspended projects:

Could someone help please?

[v-yangliu-msft · Accepted solution]

Hi  @skills29 ,

Here are the steps you can follow：

1. Create calculated table.

Table 2 =
DISTINCT('Table'[Status])

2. Create measure.

Measure =
var _select=SELECTCOLUMNS('Table 2',"1",[Status])
var _proj=
SELECTCOLUMNS(
    FILTER(ALL('Table'),'Table'[Status] in _select),"1",[ProjectName])
return
IF(
    MAX('Table'[ProjectName]) in _proj ,MAX('Table'[Status]),BLANK())

3. Result:

Best Regards,

Liu Yang

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

[skills29]

Thank you so much, it has worked!