topic Re: Need To help to create a measure on top of Measures in DAX Commands and Tips

Need To help to create a measure on top of Measures

sb48846 — Thu, 25 Jul 2024 16:54:55 GMT

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.

Re: Need To help to create a measure on top of Measures

MalkhazTsagarel — Thu, 25 Jul 2024 18:14:01 GMT

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.

Re: Need To help to create a measure on top of Measures

sb48846 — Fri, 26 Jul 2024 12:21:13 GMT

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.

Re: Need To help to create a measure on top of Measures

MalkhazTsagarel — Sat, 27 Jul 2024 12:15:03 GMT

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

Re: Need To help to create a measure on top of Measures

MalkhazTsagarel — Sun, 28 Jul 2024 16:45:12 GMT

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