I'm trying to create a table/matrix visual that will display the name of a producer and the top product they've sold based on the total number of sales. I've included a sample dataset to give you an idea of what I've got and the expected output.
Go to Solution.
1. Place Table1[Producer] in the rows of a visual table
2. Place this measure in the visual:
VAR AuxTable_ =
DISTINCT ( Table1[Product] );
TOPN ( 1; Table1; CALCULATE ( SUM ( Table1[Sales] ); ALL ( Table1[Sales] ) ) )
CONCATENATEX ( AuxTable_; [Product]; ", " )
Please mark the question solved when done and consider giving kudos if posts are helpful.
View solution in original post
Thanks for the quick response. That seems to get me what I needed with the addition of a RETURN FIRSTNONBLANK to eliminate multiple products being returned.
Check out the on demand sessions that are available now!
Check out the Winners!
Features releasing from October 2020 through March 2021