Compare Two Columns

ryan_mayu Thanks for your prompt reply!

Hi Syndicate_Admin 

Please consider using an aggregation function to derive a single price value. For example, you might want to use the average, minimum, or maximum price.Here's how you could modify your measure to use the average, minimum, or maximum price.

AVERAGE

Measure 3 = 
AVERAGEX(
    FILTER(
        olist_order_items_dataset,
        olist_order_items_dataset[product_id] = olist_products_dataset[product_id]
    ),
    olist_order_items_dataset[price]
)

MAX

Measure 3 = 
MAXX(
    FILTER(
        olist_order_items_dataset,
        olist_order_items_dataset[product_id] = olist_products_dataset[product_id]
    ),
    olist_order_items_dataset[price]
)

MIN

Measure 3 = 
MINX(
    FILTER(
        olist_order_items_dataset,
        olist_order_items_dataset[product_id] = olist_products_dataset[product_id]
    ),
    olist_order_items_dataset[price]
)

Best Regards,

Jayleny