Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

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

  • Stachu's avatar
    Stachu
    Community Champion

    you could achieve something like this by ussing SUMMARIZE/GROUPBY for colours, and then RANKX/TOPN

    • Anonymous's avatar
      Anonymous
      Not applicable

      Thanks for your help.

       

      No needed measure , TopN  = 1 in the Filter levels was enought :-)