How to calculate Average value for each category

[MarshalSK]

Hi Folks, How to achieve Average Sales for each category ? Note: if you have Filters it should affect the visual

[MarshalSK]

@AlexisOlson  - Thanks for the prompt response. To give you a big pitcure. I am trying to create year wise average line , even if i apply Region filter average should be calculated after filtering the data.

[AlexisOlson]

If you want a flat average line, then you'll need to remove the date filter context.

For example,

CALCULATE (
    AVERAGE ( Table1[Sales] ),
    ALLSELECTED ( Table1[Year], Table1[Quarter] )
)

There are two approaches:

1. Specify what filters you want to remove (and keep all others) using ALL or ALLSELECTED.

2. Specify what filters you want to keep (and remove all others) using ALLEXCEPT.

[AlexisOlson]

It depends on how exactly you want it to work in general (what columns to ignore and what not to), but I'd start with something like this:

CALCULATE (
    AVERAGE ( Table1[Sales] ),
    ALLSELECTED ( Table1[Sub Category] )
)

This tells it to remove the visual's filter context on Sub Category.

[MarshalSK]

Hi @AlexisOlson , I need to calculate Average line per year, It should accomdate the filters. average line should be calculated on top of filtered data set. 

if you aware of super store data set , can you try from your end and let me know the solution.