Forum Discussion
Mesure selecting max quantity items
Imagine a scenario:
As is shown in the capture , I have a list of color. My goal is show in a card the name of the color with major number of times that appear in the table and if I filter the result for example, selecting jacket, the color change or not depending the quantity of jackets for each color showing the name of the color color. (I don't know if I'm explaining clear sorry)
I don't know how to do this measure, I'm really lost with that.
Thanks in advance
you could achieve something like this by ussing SUMMARIZE/GROUPBY for colours, and then RANKX/TOPN
2 Replies
- StachuCommunity Champion
you could achieve something like this by ussing SUMMARIZE/GROUPBY for colours, and then RANKX/TOPN
- AnonymousNot applicable
Thanks for your help.
No needed measure , TopN = 1 in the Filter levels was enought :-)