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

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more

Reply
ShubhamK280394
New Member

Aggregating values using dax at specific level

Hi Team, 

 

I have a matrix table in following manner:

 

Market--) Category - -) sub category - -)

 

Now i have sales at Market level say 5000$ then at category level i have sales ( Category A : 2000,B:3000) and sub category (A1 :1000,A2:1000, B1 - - 1000, B2 :1000,B3:1000)

 

I want to create Market value sales measure to get below result 

 

A 5000

B 5000

A1 2000

A2 2000

B1 3000

B2 3000

B3 3000

 

Could you please help me achieve this result? 

1 REPLY 1
Mahesh0016
Super User
Super User

@ShubhamK280394 

Mahesh0016_0-1673258626019.png

 

 

*If this post helps, please consider accept as solution to help other members find it more quickly and Appreciate your Kudos.

Helpful resources

Announcements
Power BI DataViz World Championships

Power BI Dataviz World Championships

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!

December 2025 Power BI Update Carousel

Power BI Monthly Update - December 2025

Check out the December 2025 Power BI Holiday Recap!

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.