Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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,
Solved! Go to Solution.
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
@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?
Check out the July 2025 Power BI update to learn about new features.
User | Count |
---|---|
72 | |
72 | |
38 | |
31 | |
26 |
User | Count |
---|---|
97 | |
86 | |
43 | |
40 | |
35 |