Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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?
*If this post helps, please consider accept as solution to help other members find it more quickly and Appreciate your Kudos.
Check out the July 2025 Power BI update to learn about new features.
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
User | Count |
---|---|
69 | |
68 | |
40 | |
29 | |
26 |
User | Count |
---|---|
89 | |
49 | |
44 | |
38 | |
37 |