Forum Discussion
Display Corresponding Measure Values on an Advance Card
Super UserYou need to get the location for max value like this and then create a similar kind of filter again
location 1 = calculate(max(location[location],filter(table,table[Costs per Sq Meter MAX]= [WHS Fixed Costs per Sq Meter MAX] ))Appreciate your Kudos. In case, this is the solution you are looking for, mark it as the Solution. In case it does not help, please provide additional information and mark me with @
Thanks. My Recent Blog -
https://community.powerbi.com/t5/Community-Blog/HR-Analytics-Active-Employee-Hire-and-Termination-trend/ba-p/882970
https://community.powerbi.com/t5/Community-Blog/Power-BI-Working-with-Non-Standard-Time-Periods/ba-p/881739
https://community.powerbi.com/t5/Community-Blog/Comparing-Data-Across-Date-Ranges/ba-p/823601
This measure is returning the last location alphabetically and if i were to change it to MIN it returns the first location alphabetically. Is there something else to make the corresponding location to the maximum location value?
Thanks