Table with a norm

[Anonymous]

Hi there,

I am currently working on a productivity dashboard. I have received durations from workers, on how long certain tasks are taking. What i now want to do is, have all of these durations as a bar chart, i succeeded in that. But I would also like to have a line that shows the norm of the workers. I have a table for this, with multiple norms for certain tasks. But i only need one value from this colomn. So how can i select only one value from this colomn, to show this as a norm in my graph?

[Anonymous · Accepted solution]

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.