Forum Discussion
ax80
3 years agoNew Member
Understand columns with minimum value
Hi all in my main page I show the minimum value of a measure (i.e. cost). How can I understand and display (maybe with a tooltip) what are the columns that have such minimum value? So in my case wh...
Adamboer
Responsive Resident
3 years agoOne way to achieve this would be to create a separate measure that returns the name of the product with the minimum cost. You can use the MINX function to find the minimum cost and then use RELATED to return the corresponding product name. Here's an example formula: Product with Min Cost = VAR MinCost = MINX(ALLSELECTED(Table1), [Cost]) RETURN IF([Cost] = MinCost, RELATED(Table1[Product]), BLANK()) Once you have this measure, you can add it to the tooltip of the main page measure. The tooltip will then display the name of the product with the minimum cost whenever the user hovers over the minimum value. Note that this approach assumes that the product names are unique. If there are multiple products with the same minimum cost, this measure will only return the first one it encounters.