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

Get Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Learn more

Reply
Anonymous
Not applicable

Matrix Measure Values

My data set has 3 measure that produce the values in required qty, last unit cost and projected cost. 

To get projected cost its measure requiredqty * Last unit cost. 
I dont care about the sub totals for required qty and last unit cost but how do i get projected cost to display the total of the column and not the multplied sub total of required qty and last unit cost 
 

bhatfield_0-1705461708090.png

 

2 REPLIES 2
Anonymous
Not applicable

They are all from different tables. I think i follow but maybe with this info you can clarify the measure a little more

bhatfield_1-1705501319317.png

bhatfield_2-1705501479618.png

bhatfield_3-1705501517800.pngbhatfield_4-1705501533143.png

bhatfield_5-1705501558406.png

bhatfield_6-1705501588952.png

 

 

 

amitchandak
Super User
Super User

@Anonymous , it they are from same table you should create a meausre like

 

Sumx(Table, [qty] * [Last unit cost])

 

 

If they are from different tables then  you summarize them based on columns in the visual

 

Sumx(Summarize(Table, Table[COl1], Dim[Col1], "_1", Sum(Table[Qty]) , "_2", Max(Table[Price]) ) , [_1] *[_2])

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

Helpful resources

Announcements
Fabric Data Days Carousel

Fabric Data Days

Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!

October Power BI Update Carousel

Power BI Monthly Update - October 2025

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

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.

Top Solution Authors