Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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?
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
114 | |
99 | |
83 | |
70 | |
60 |
User | Count |
---|---|
150 | |
115 | |
104 | |
89 | |
65 |