Advance your Data & AI career with 50 days of live learning, dataviz contests, hands-on challenges, study groups & certifications and more!
Get registeredGet Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Learn more
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
They are all from different tables. I think i follow but maybe with this info you can clarify the measure a little more
@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])
Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!
Check out the October 2025 Power BI update to learn about new features.