cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Regular Visitor

Multiple slicers multiple selection not summing to the correct value

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:

A10
B20
C5
D5
E25
F35

 

 This gives correct no. in the card 100

  100
Slicer 1Slicer 2 
All All  

 

 

This gives wrong value, it should give 110, instead, it's giving only 10 

  10
Slicer 1Slicer 2 
AAll  

Helpful resources

Announcements

August Community Highlights

Check out a full recap of the month!

August 2020 CYST Challenge

Check out the winners of the recent 'Can You Solve These?' community challenge!

Experience what’s next for Power BI

Join us for an in-depth look at the new Power BI features and capabilities at the free Microsoft Business Applications Launch Event.

Top Solution Authors