Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
shubhrika
Frequent Visitor

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

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:

Categorysub-categoryScore
AnimalDog1
AnimalCat2
AnimalHorse3
MineralQuartz1
MineralSilica2
Mineralgypsum1
Mineralfeldspar2
Vegetablecarrot3
Vegetabletomato1

 

I want the output as:

 

Dog1
Cat2
Horse3

 

Thanks in advance!

1 ACCEPTED SOLUTION
amitchandak
Super User
Super User

@shubhrika , Not sure I got it

Try a measure like this with sub category

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

Share with Power BI Enthusiasts: Full Power BI Video (20 Hours) YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube

View solution in original post

3 REPLIES 3
Anonymous
Not applicable

@shubhrika 

 

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

amitchandak
Super User
Super User

@shubhrika , Not sure I got it

Try a measure like this with sub category

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

Share with Power BI Enthusiasts: Full Power BI Video (20 Hours) YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube

@amitchandak thanks alot! It worked

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

Find out what's new and trending in the Fabric community.

July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.