Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

alternative to lookupvalue function

Hi everyone,   I'm trying to look up values using this sample formula in a measure : Max Category = LOOKUPVALUE (Table1[Col_to_lookup], Table1[col_num], Table1[Max(Table1[col_num])])   Then, I w...
Need Help
Tips and Tricks
PaulDBrown's avatar
PaulDBrown
Icon for Community Champion rankCommunity Champion
4 years ago

It seems like you are looking up values from the same table, correct? (all columns refer to table 1)

Can you show a depiction of your model?

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    Hello Paul,

     

    Yes indeed, all columns refer to the table RegNuance (Table 1). Here are my model and the first rows of this table.

     

    Then I go to the conditionnal formatting of my shape map. I encounter no problem with the coloration of the map, but I have issues using the slicer of the category RegNuance[Code Nuance].

     

    Thanks

     

    model

     

    RegNuance

     

    coloration of the map

     

     

     

    • Anonymous's avatar
      Anonymous
      Not applicable
      4 years ago

      Hi everyone,

      To sum to, I want to :

      - Retrieve in a measure the color code RegNuance[Couleur Nuance] corresponding to the maximum of votes  Max Voix = MAX('RegNuance'[Voix])

      - Use this measure to color the shape map in the filtering context (division by region) ex. [code de la région]

      Is it the good way to proceed or am I wrong ?

      I can upload my file if needed.

      • PaulDBrown's avatar
        PaulDBrown
        Icon for Community Champion rankCommunity Champion
        4 years ago

        Please share sample data or a mock PBIX file