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

The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. Register Now

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
Fabric Community Conference

Microsoft Fabric Community Conference

Join us at our first-ever Microsoft Fabric Community Conference, March 26-28, 2024 in Las Vegas with 100+ sessions by community experts and Microsoft engineering.

February 2024 Update Carousel

Power BI Monthly Update - February 2024

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

Fabric Career Hub

Microsoft Fabric Career Hub

Explore career paths and learn resources in Fabric.

Fabric Partner Community

Microsoft Fabric Partner Community

Engage with the Fabric engineering team, hear of product updates, business opportunities, and resources in the Fabric Partner Community.

Top Solution Authors