How to work out averages based on many categories

[lennox25]

Can someone help me? I need to create a visual that displays the average per category? How do I do this? Can it be done with one measure/column?

There are filters on visual on store number and date.

I have uploaded a sample power bi file which will hopefully explain what Im after.

https://drive.google.com/file/d/1fFS2O-SYE1IBKjfJHlgc8CPTEHNi86-i/view?usp=sharing 

[Mahesh0016]

I hope this solution is helpful.
Thank You!

[lennox25]

Hi @Mahesh0016  Thank you, but I cant get this to work. Have you looked at my sample data? Does it work for you?

[v-rzhou-msft]

Hi @lennox25 ,

Here I suggest you to create a measure by below code.

Avg =
CALCULATE (
    AVERAGE ( 'TableName'[COLUMN1] ),
    FILTER (
        ALLSELECTED ( [Store Number], [Date] ),
        'TableName'[Category] = MAX ( 'TableName'[Category] )
    )
)

I couldn't get access to your sample file from your link.

If this reply still couldn't help you solve your issue, please share a new link with me.

Best Regards,
Rico Zhou

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

[lennox25]

@v-rzhou-msft I still cant get it to work. Apologies re access to file, you should ahve it now, Many Thanks