Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Creating a Visual of Unique Combinations

Hi all,

 

I am trying to create a table that shows a unique combination based off criteria.

 

Ex: 

Product:   Rank    Price

a                10          5

b                12        10

c                 9           7

 

Id like to find a unique combination of the highest ranked products that fit into a certain budget. Thoughts? Thanks!

Need Help

6 Replies

  • amitchandak's avatar
    amitchandak
    Icon for Super User rankSuper User
    4 years ago

    Anonymous , I do not see two column

     

    If you need more than one column in Rank

     

    You can use

    ranxk(allselected(Table[Product], table[Rank]), calculate(Sum(Table[Price])), ,desc,dense)

     

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    Hi Anonymous ,

     

    Try applying filters to visual.

    If this does not work for you, can you provide sample data and show the expected output? Thanks in advance.

     

    Best Regards,
    Gao
    Community Support Team

     

    If there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly. If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

    How to get your questions answered quickly -- How to provide sample data

    • Anonymous's avatar
      Anonymous
      Not applicable
      4 years ago

      So out of this data I'd like to create a table like you posted above. (Player, allocated points, DK price) the criteria would be to get the combination of 6 players with the highest sum of allocated points to fit a 50k budget. Thanks

      • Anonymous's avatar
        Anonymous
        Not applicable
        4 years ago

        Hi Anonymous ，

         

        Suppose there is such a table. Sort by allocated points.

        New a column.

        Column = 
VAR _ranking ='Table'[Ranking]
var _budget = 
CALCULATE(SUM('Table'[DK Price]),FILTER('Table','Table'[Ranking]>=_ranking&&'Table'[Ranking]<=_ranking+5))
VAR _matched = IF(_budget<50000,'Table'[Ranking])
RETURN
_matched

        New a table.

        Table 2 = 
VAR _min = MIN('Table'[Column])
RETURN
FILTER('Table','Table'[Ranking]>=_min && 'Table'[Ranking]<=_min+5)

        Attached PBIX file for reference.

         

        Best Regards,
        Gao
        Community Support Team

         

        If there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly. If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

        How to get your questions answered quickly -- How to provide sample data