Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

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
July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

July Newsletter

Fabric Community Update - July 2024

Find out what's new and trending in the Fabric Community.