Forum Discussion
Dax logic
{ FIXED [Item Description] :MIN({ Fixed [Item Description] ,[Vendor],[Purchase Order]:SUM([Unit Price])})} replicate this in power bi.
Try the below logic for DAX:
MinUnitPricePerItemDescription = MINX( SUMMARIZE( TableName, TableName[Item Description], TableName[Vendor], TableName[Purchase Order], "SumUnitPrice", SUM(TableName[Unit Price]) ), [SumUnitPrice] )Replace TableName with the actual table where the columns reside.
Try the below logic for DAX:
MinUnitPricePerItemDescription =
MINX(
SUMMARIZE(
TableName,
TableName[Item Description],
TableName[Vendor],
TableName[Purchase Order],
"SumUnitPrice", SUM(TableName[Unit Price])
),
[SumUnitPrice]
)
Replace TableName with the actual table where the columns reside.