How to write a DAX query to display the subcategory along with it's value for a specific category?

[shubhrika]

Hi All,

I want to write a DAX query to show the subcategory along with the Score for a particular category.

For ex- I want to display the sub-category values belonging to animal category. The input is:

Category	sub-category	Score
Animal	Dog	1
Animal	Cat	2
Animal	Horse	3
Mineral	Quartz	1
Mineral	Silica	2
Mineral	gypsum	1
Mineral	feldspar	2
Vegetable	carrot	3
Vegetable	tomato	1

I want the output as:

Dog	1
Cat	2
Horse	3

Thanks in advance!

[Anonymous]

@shubhrika 

You want a DAX query or a DAX measure? These are 2 totally different things...

[amitchandak · Accepted solution]

@shubhrika , Not sure I got it

Try a measure like this with sub category

calculate(sum(Table[Score]) , filter(Table, Table[Category] = "Animal"))

[shubhrika]

@amitchandak thanks alot! It worked