Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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
Solved! Go to 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
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
User | Count |
---|---|
92 | |
85 | |
77 | |
66 | |
62 |
User | Count |
---|---|
110 | |
95 | |
95 | |
64 | |
59 |