Forum Discussion
Slicers Don't Work
Ok. See if this is what you want. See the attached PBIX file. Please note the formula will not work unless you have Pen and/or Pencil selected and Paper and/or Notebook. In other words, if you only select Pen and Pencil, the formula returns nothing because there is no denominator.
Sorry for being too vague.
See dataset.
| Date | Store | Product | Amount |
| Feb-1 | A | Pen | 10 |
| Feb-1 | A | Pencil | 20 |
| Feb-1 | A | Notebook | 30 |
| Feb-1 | A | Paper | 40 |
| Feb-1 | B | Pen | 10 |
| Feb-1 | B | Pencil | 20 |
| Feb-1 | B | Notebook | 30 |
| Feb-1 | B | Paper | 40 |
...
EXCEL FORMULA = ( SUMIF(Product,"Pen",Amount) + SUMIF(Product,"Pencil",Amount) ) / ( SUMIF(Product,"Notebook",Amount) + SUMIF(Product,"Paper",Amount) )
GOAL - I want to have two slicers: store and product. Both should affect formula, e.g. unselecting "Pen" should set 0 amount in formula for "Pen"
Community ChampionOk. See if this is what you want. See the attached PBIX file. Please note the formula will not work unless you have Pen and/or Pencil selected and Paper and/or Notebook. In other words, if you only select Pen and Pencil, the formula returns nothing because there is no denominator.