Need To help to create a measure on top of Measures

[sb48846]

Hi Team,

I need your help on creating measure on top of measure. Please see below date where following fields are measures.

 

Mesures List:

Bid Price (Formula: =CALCULATE(SUM('Lowest Price Option'[Daily Price]))

Qty Bid  (Formula: =CALCULATE(SUM('Lowest Price Option'[Qunatity Bid]))

Total Qty bid by all Suppliers (Formula: = CALCULATE(SUM(Bid[Demand]), ALLSELECTED(Bid)))

QtySplit% by Mkt&Supplier  (Formula: = Divide([Qty Bid],[Total Qty bid by all Suppliers])

Qty Weig.price by Mkt&Supplier (Formula : = [Bid Price]*[QtySplit% by Mkt&Supplier]) 

Trying to create new measure called "NewMeasure(Group by BidYear,Market&Date)" on top of measure "Qty Weig.price by Mkt&Supplier" and this new measure should group the totals based on Bid Year, Market, Price Date& Product.

I need expected result in column "L"

Thanks,

Suman.

[MalkhazTsagarel]

@sb48846  If it worked, please mark it as a solution. Thanks!

[MalkhazTsagarel · Accepted solution]

This will give the result:
Total Qty bid by All Suppliers =

CALCULATE(

   [Qty Bid],ALLSELECTED('Sample Data'[Supplier],'Sample Data'[Daily Bid Price],'Sample Data'[Location]))

If it works, please make it as solution

[MalkhazTsagarel]

Hey, 
Try this dax code for a new measure:
NewMeasure =
SUMX(
SUMMARIZE(
'Bid',
'Bid'[Bid Year],
'Bid'[Market],
'Bid'[Price Date],
'Bid'[Product],
"Qty Weig.price by Mkt&Supplier", [Qty Weig.price by Mkt&Supplier]
),
[Qty Weig.price by Mkt&Supplier]
)

I use Summarize to create a table grouped by the specified columns  and then to sum the 'Qty Weig.price by Mkt&Supplier' for each group using Sumx.

[sb48846]

Hi @MalkhazTsagarel 

I have tried your suggestion on "Total Qty bid by All Suppliers" measure first. It is not sumarizing the Qty Bid as expected. Please get the  Pbix file from below link.

https://drive.google.com/file/d/1_-qKhnDMCtkdLT869axnLTOw9m4Wo645/view?usp=drive_link

See the below output which i am getting.

Thanks,

Suman.