Filtered Average Value

Hi, Anonymous 

According to your description, you want to create a measure to get a column chart as you expected, you can try this measure:

This is my test data, I added some data based on yours to display value for each column in the chart, like this:

Average = 
CALCULATE(
    AVERAGE('Table'[Value]),
    FILTER(
        ALLSELECTED('Table'),
        [Tool]=MAX('Table'[Tool])&&
        [Requirements Level 1]=MAX('Table'[Requirements Level 1] )))

Then I create a Clustered column chart and placed it like this:

And you can get what you want.

You can download my test pbix file here

Best Regards,

Community Support Team _Robert Qin

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