Returning the maximum value from a table (or ideally, a box/whisker plot) to display in a card

Hi chickenlicken ,

If i understand you correctly, you can use Measures to achieve your purpose.

Here's some sample data and measures

max = MAX('Table'[Amount])
min = MIN('Table'[Amount])
score = [max]/[min]

The values of max or min will be changed by slicers or page level filters and the value of formula which is using these changing values will also be changed.

For more details please check the documents below.

https://docs.microsoft.com/en-us/power-bi/desktop-measures.

https://docs.microsoft.com/en-us/power-bi/desktop-tutorial-create-measures.

BTW, if you want one of the visual to be unaffected,

for slicers, please inactive the interactions:

for filters, please use visual level filters.

Best Regards,

Jay

Community Support Team _ Jay Wang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.