Forum Discussion

abartozzi's avatar
abartozzi
Frequent Visitor
5 years ago
Solved

Lowest Value Name

Hi community,    Have tried some ideas but didn't work out.  I have this pivot table:     So as you can see, for every date there are multiple entries depending on the OTA. What I also ha...
Need Help
  • v-xulin-mstf's avatar
    v-xulin-mstf
    5 years ago

    Hi abartozzi,

     

    Depending on your data structure, calculating the field name corresponding to the maximum value in different fields is not supported, perhaps you can change the data structure to unpivot 'AVES', 'Bookling.com', 'Agoda.com', etc. into one column as follows.

    Then try measure as:

     

    Measure 2 = 
IF(
    [Measure]=MAXX(FILTER(ALL('test table'),'test table'[Category]=MAX('test table'[Category])),[Measure]),
    MAX('test table'[Subcategory]),
    BLANK()
)

     

    I added this into the demo, please try it.

     

    If you still have some question, please don't hesitate to let me known.‌‌

     

    Best Regards,

    Link

     

    Is that the answer you're looking for? If this post helps, then please consider Accept it as the solution. Really appreciate!

v-xulin-mstf's avatar
v-xulin-mstf
Community Support
5 years ago

Hi abartozzi,

 

Try measure as:

Measure=
if(
   [Rate]=Minx(filter(all'table','table'[hotel]=max('table'[hotel])),[Rate]),
   max('table'[OTAs]),
   blank()
)

If you still have some question, please don't hesitate to let me known.‌‌

 

Best Regards,

Link

 

Is that the answer you're looking for? If this post helps, then please consider Accept it as the solution. Really appreciate!

  • v-xulin-mstf's avatar
    v-xulin-mstf
    Community Support
    5 years ago

    Hi abartozzi,

     

    Depending on your data structure, calculating the field name corresponding to the maximum value in different fields is not supported, perhaps you can change the data structure to unpivot 'AVES', 'Bookling.com', 'Agoda.com', etc. into one column as follows.

    Then try measure as:

     

    Measure 2 = 
IF(
    [Measure]=MAXX(FILTER(ALL('test table'),'test table'[Category]=MAX('test table'[Category])),[Measure]),
    MAX('test table'[Subcategory]),
    BLANK()
)

     

    I added this into the demo, please try it.

     

    If you still have some question, please don't hesitate to let me known.‌‌

     

    Best Regards,

    Link

     

    Is that the answer you're looking for? If this post helps, then please consider Accept it as the solution. Really appreciate!