cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
abukapsoun
Post Patron
Post Patron

Sum of values based on filter

Hi,

 

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

Customer IDCustomer name
1XX
2YY
3ZZ

 

 

Then I have another one

Customer IDValue
120
230
340
450
560

 

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,

 

 

1 ACCEPTED SOLUTION

it worked by applying a filter on the page level

 

View solution in original post

4 REPLIES 4
Icey
Community Support
Community Support

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
Super User
Super User

@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

it worked by applying a filter on the page level

 

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

 

Helpful resources

Announcements
Carousel_PBI_Wave1

2023 Release Wave 1 Plans

Power BI release plans for 2023 release wave 1 describes all new features releasing from April 2023 through September 2023.

Power BI Summit Carousel 2

Global Power BI Training

Make sure you register today for the Power BI Summit 2023. Don't miss all of the great sessions and speakers!

BizApps LATAM 2023

Business Application LATAM Summit 2023

Join the biggest FREE Business Applications Event in LATAM this February.

Power Platform Bootcamp

Global Power Platform Bootcamp

In this bootcamp we will deep-dive into Microsoft’s Power Platform stack with hands-on sessions and labs, delivered to you by experts and community leaders.