How to change filters behavior?

[Anonymous]

I have the following table:

Seller        Client       Value

Tom	Client_1	7227
Tom	Client_3	9974
Dicsk	Client_2	3098
Dicsk	Client_3	3667

Like you can notice, the Client_1 is Tom's client, Client_2 is Dicsk's client and Client_3 is a client from both sellers. I'm using this data to create a matrix and a simple filter, like this:

Using the filters I get this:

But I want something different from that. I want that my filter behaves like this:

Is it possible?  If yes, how can I do this?

[v-huizhn-msft · Accepted solution]

Hi @Anonymous,

I try to reproduce your scenario, please review the following steps.

1. Create a new table including Clients by "New Table" under Modeling on Home page. Please notice there is no relationship between New Table and your resource table.

 

2. Create measure using the formula.

new-value = VAR Client=IF(ISFILTERED(Table1[Client]),CALCULATE(FIRSTNONBLANK(Table1[Client],Table1[Client]),ALLSELECTED(Table1)),BLANK())
RETURN IF(ISBLANK(Client),SUM(Test[Value]),IF(FIRSTNONBLANK(Test[Client],Test[Client])=Client,SUM(Test[Value]),"Not a Client"))

3. Create a slicer including Table1[Client] and a table visual to display the result.


We are unable to get The total row, because the "Not a Client" is text type, which can not be calculated. Please download the attachment file to test.

Best Regards,
Angelia

[Anonymous]

Perfect, @v-huizhn-msft. I thought that was impossible to calculate the total. I will change the "Not a Client" to zero. So I can calculate de grand total. Thank you.