Average per Category that ignores slicers for that exact category

[Barnee]

Hi!
I would need some help with the following situation which I have trouble solving.

I'd like to create an average per category in a measure that ignores slicer selection for the same category.

I tried by using ALL function, but it has an effect on the VALUES part of the measure as well.

Total Session by Campaign = 
CALCULATE(
AVERAGEX(
	KEEPFILTERS(VALUES('Analytics'[Campaign])),
	CALCULATE([Total Sessions])
), ALL('Analytics'[Campaign])
)

I possible, I would need to solve this inside the measure since I can't disable visual interactions in this use-case.
Thanks in advance and reach out if any more detail is needed.

Barna

[amitchandak]

@Barnee , you are using keep filter and all on same field

Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.

[Barnee]

hi @amitchandak 

here is the link where you can find the pbix

[v-yiruan-msft · Accepted solution]

Hi @Barnee ,

Please update the formula of your measure "Total Sessions average per Campaign for all the campaigns" as below:

Total Sessions average per Campaign for all the campaigns = AVERAGEX(ALL(sampledata[Campaign]),[Total Sessions])

I updated it in your sample file, you can get the file from this link.

Best Regards

Rena

[Barnee]

thanks, @v-yiruan-msft ! I see now

Barna