Measure with 2 slicers that do not filter filter each other. Is this possible?

[DforData]

Hi everyone,

I'm working on a Power BI report page that includes two slicers:

• Client Name (Customer_info[Client_Name])
• Region (Customer_info[Region])

I've edited the interactions so that selecting one slicer does not filter the other. However, I'm encountering an issue with displaying the selected customer name when a different region is selected.

I've created the following measure:

SelCustomer =
VAR SelectedCustomer = SELECTEDVALUE(Customer_info[Name_NA])
RETURN
    CALCULATE(
        SelectedCustomer,
        REMOVEFILTERS(Customer_info[Region])
    )

Goal: I want the selected customer name (SelCustomer) to always be displayed, even if I select a region that is different from the customer's region. Essentially, the customer name should remain visible regardless of any region selection.

Issue: Currently, when I select a region that doesn't match the selected customer's region, the customer name disappears from the visuals. I have tried ALL(), ALLEXCEPT(), REMOVEFILTERS() but nothing seems to work.

Question: Is it possible to achieve this in Power BI? If so, how can I modify my measure or report settings to display the selected customer name regardless of the region selected?

Thank you for your assistance!

[lbendlin · Accepted solution]

I've edited the interactions so that selecting one slicer does not filter the other. 

That won't work with columns from the same table. Instead, use disconnected tables to feed both slicers.

[DforData]

Thanks for your response. 

I spent so much time working on this that I didn;t want to accept it and I haven't found any information online. Now, with this response, I will proceed with a different solution.