Remove filter from column but keep filter from row in matrix

[matsu]

Hi,

I have two tables linked by "Project Name". I put [Count Project] in the matrix with "Company" on the row and "Lv2" on the column.

pbix:

https://drive.google.com/file/d/1fOSTJfkfMpbK1nqa5W75cJ9L4DvENyWq/view?usp=sharing 

To highlight all values of our client (including blank, so I add +0 in [Count Project]), I use [Our Client Color] to conditionally formatting the background of the [Count Project].

In [Our Client Color], the REMOVEFILTERS ( 'Levels' ) is to remove filter from the column, otherwise "CCC crossing Mid" will not be highlighted. However, with this REMOVEFILTERS, DDD is highlighted as well.

I've tried many ways such as using TREATAS but still can't work. Any helps? Thanks!

Count Project :=
CALCULATE ( COUNT ( Main[Project Name] ) ) + 0

Our Client Color :=
VAR isOurClient =
    CALCULATE (
        [Count Project],
        Main[OurClient] = TRUE (),
        REMOVEFILTERS ( 'Levels' )
    )
RETURN
    IF ( isOurClient, "Yellow", "" )

without REMOVEFILTERS

with REMOVEFILTERS 

[v-eqin-msft · Accepted solution]

Hi @matsu ,

According to my understand, you want to highlight the blank value of AAA and CCC as well, right?

Just use  REMOVEFILTERS('Levels'[Lv2]), then the visualization looks right like this:

Did I answer your question? Please mark my reply as solution ,thank you.

If you have any questions, please upload some insensitive data samples .

Best Regards,

Eyelyn Qin

[amitchandak]

@matsu , Not very clear on the need to removefilter level .Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.

Try color measure like

if(max(Main[OurClient]) = TRUE (), "yellow", blank())

[matsu]

@amitchandak 

Without the removefilter, the blank value (zero) of AAA and CCC in the matrix will not be highlighted by the color measure. I tried your color measure but it showed error. I attached the sample file with the link. Thanks.

[matsu]

@amitchandak, Without the removefilter, the blank value (zero) of AAA and CCC  in the matrix can't be highlighted by the color measure. I tried the measure you provided but showing errors. I attached the sample with the link. Thanks. 

pbix: 

https://drive.google.com/file/d/1fOSTJfkfMpbK1nqa5W75cJ9L4DvENyWq/view?usp=sharing