Dax logic

[Anonymous]

{ FIXED [Item Description] :MIN({ Fixed [Item Description] ,[Vendor],[Purchase Order]:SUM([Unit Price])})}
replicate this in power bi.

[ChiragGarg2512 · Accepted solution]

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.

[ryan_mayu]

could you pls provide some sample data and expected output?