Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more
Hi, I have 2 different slicers each having different products; say Slicer 1 has 3 products-A, B, C, and Slicer 2 has 3 products-D, E, F. When I am selecting All values from both slicers it's giving me a correct cumulative added value in the card. But if I select any 1 or more values (but not all), the card value gets adjusted only to one slicer and doesn't give value summing up the selected values of both the slicer. Can someone please help me with this? calculate('Metrics'[Revenue], filter('Product',Product'[Product X]in {"A","B","C","D","E","F"}),FILTER('Calender','Calendar'[Quarter] in {2020Q1,2020Q2})) .
This is my table:
| A | 10 |
| B | 20 |
| C | 5 |
| D | 5 |
| E | 25 |
| F | 35 |
This gives correct no. in the card 100
| 100 | ||
| Slicer 1 | Slicer 2 | |
| All | All |
This gives wrong value, it should give 110, instead, it's giving only 10
| 10 | ||
| Slicer 1 | Slicer 2 | |
| A | All |
The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!
| User | Count |
|---|---|
| 10 | |
| 5 | |
| 5 | |
| 4 | |
| 3 |