Forum Discussion
Dynamically grouping table based on user input
Say you have a table like the below where max margin and min margin represent the max and min of margin within the existing table: Country Margin Max Margin Min Margin Germany 50 80 40 ...
Max Margin=CALCULATE(MAX(Table[Margin]),ALL(Table[Country]))
Min Margin=CALCULATE(MIN(Table[Margin]),ALL(Table[Country]))