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.
2 Replies
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.
could you pls provide some sample data and expected output?