Hello @Pete673,
Thank you for posting the query on to the Forum.
This type of similar query was asked onto the forum and @sam.mckay had addressed this query.
Also he has prepared a video on this.
I’m providing the links of the video and also of the query which was posted onto the Forum for the reference.
Hoping you’ll find this useful and can help you to achieve your desired analysis.
Please feel free to write back in case I’ve missed out on anything.
Thanks and Warm Regards,
Harsh
[Query Posted on the Forum] -
(Product Name as Measure for Highest Sales Product)
[Video of Showing Top Product in Card Visual] -
