Sum of values based on filter

[abukapsoun]

Hi,

Need your kind support please. I have the following two tables

Customer ID	Customer name
1	XX
2	YY
3	ZZ

Then I have another one

Customer ID	Value
1	20
2	30
3	40
4	50
5	60

Then I have a relationship between both tables based on customer ID. I have a slicer based on customer name and I want to compute the sum of value

In the slicer I can see options for customer 1, 2, 3 to select.. if i select the three of them, the value is summed correctly

if in the slicer I select All, then a card with the sum of values is giving me the value for all the customers 1,2,3,4,5

how could that be possible? How can I limit the "All" in the slicer to display only customers 1,2,3

Thanks,

[Icey]

Hi @abukapsoun ,

Glad to hear that the problem has been solved. Pleaseaccept the replies making sense as the solution. Your contribution is highly appreciated.

Best Regards,

Icey

[amitchandak]

@abukapsoun , As your customer table do not have all customer.

if you do not select any filter value, means all/none. If there if not filter and it gives you everything from the second table .

If you use a filter then you will get only get those value

The default is right join (1-M) with filter it is inner join

[abukapsoun · Accepted solution]

it worked by applying a filter on the page level

[abukapsoun]

Yes exactly. I tried putting a filter on the page, but it didnt work. Any idea?