MAX of all

[sabeensp]

Hello,

I'm trying to find the max price and product out of all product. I need just 1 value Max Price and the Product associated with that price.

I created a meassure MAX(Price), which is fine, but as soon I put Product on the chart, it give me max price of all the product.

Price ---- Product ---- Current Flag

$$$$$         A                      1

$$$            A                       0
$$              A                       0

$$$            A                       0

$$$            B                       1

I should see only 

$$$$$         A                       1, because it is the most expensive and flag is set to 1

Thanks

[affan · Accepted solution]

Hi @sabeensp

I hope you can acheive the required result with a simple filter. See the illustration below.

If this helped you, please mark this post as an accepted solution and like to give KUDOS .

Regards,

Affan