Table with a norm

Hi, Anonymous 

Based on your description, I created the following sample data:

I have the following chart:

I use the following DAX expression to select 450 in the norm column

standard line = CALCULATE(MAX('Table'[norms]),FILTER(ALL('Table'),'Table'[norms]=450)) 

Put it in the chart as follows:

You can choose the minimum, maximum, or average value in this column. All you need to do is change the DAX expression above to:

standard lineMAX = CALCULATE(MAX('Table'[norms]),ALL('Table')) 

I've provided the PBIX file used this time below.

How to Get Your Question Answered Quickly

If it does not help, please provide more details with your desired output and pbix file without privacy information (or some sample data) .

Best Regards

Jianpeng Li

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