Using a slicer and a filtered DAX measure

[KabirDhupelia]

Hello, I've got an issue with filtering on selected values. 

In a simplistic dataset (below):

BreedSpeciesLife expectancyPredominant colour

Labrador	Dog	10	White
German Sherphard	Dog	12	Brown
Pekingese	Dog	15	White
Border Collie	Dog	11	Black
Scottish Fold	Cat	16	Orange
Turkish Angora	Cat	17	White
Siamese	Cat	15	Beige
Maincoon	Cat	18	Brown
Parrot	Bird	90	Orange
Pigeon	Bird	4	Grey
Weaver	Bird	2	Yellow
Eagle	Bird	17	Grey

I am trying to have a measure that works with a slicer to show me the average age of a species. The goal is to be able to compare various other attributes to that average. I've created a measure that looks like this:

Species life expentancy =

var Species_Selected = SELECTEDVALUE('Life expectancies'[Species])

var Years_ = CALCULATE(SUM('Life expectancies'[Life expectancy]),ALL('Life expectancies'),'Life expectancies'[Species]=Species_Selected)

var NumBreeds_ = CALCULATE(DISTINCTCOUNT('Life expectancies'[Breed]),ALL('Life expectancies'),'Life expectancies'[Species]=Species_Selected)

Return DIVIDE(Years_,NumBreeds_)

But when I use a slicer to select the species, it only works correctly on one selection. The moment I select more than 1 species (Cat and Dog), I get a blank. What I'd like to happen when selecting multiple species is for it to sum the species life expentancies and divide that sum by the distinct number of breeds in the selected species to give an average. 

This is a dummy dataset, so picture this problem with 3 000 000 rows of info.

Thanks!

[MFelix · Accepted solution]

Hi @KabirDhupelia ,

When you use the SELECTEDVALUE it only returns a single value so when you select more than one you get the blank. Try the following measure:

Species life expentancy =

var Years_ = CALCULATE(SUM('Life expectancies'[Life expectancy]),ALLSELECTED('Life expectancies'[Species])
var NumBreeds_ = CALCULATE(DISTINCTCOUNT('Life expectancies'[Breed]),ALLSELECTED('Life expectancies'[Species])
Return DIVIDE(Years_,NumBreeds_)

[KabirDhupelia]

Thanks! Works like a charm, going to move this over to the mega dataset but I can't see why it wouldn't work if it worked on the dummy set. Thanks again