Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!To celebrate FabCon Vienna, we are offering 50% off select exams. Ends October 3rd. Request your discount now.
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])