Compare Row Value to Overall Average Respecting Slicer Filters

[_ds3000_]

Hi there,

i have a table in the following format:

ID	Dim1	Dim2	Conversions	Overall Avg
abc123	type1	blue	3	3.67
abc456	type2	red	5	3.67
cd4987	type2	green	3	3.67

I would like to compare the individual row's conversion values to the overall average of conversions. BUT this calculation should respect filters set by slicers. So, for example, there might be a slicer on the page with a dropdown for dim1 and another one with a dropdown for dim2. If the user selects one of these dropdown values, the overall average should be recalculated.

What I want as the expected outcome is a measure that changes whenever one of the slicers is changed.

So far I've only managed to create a measure that gives me the overall average IGNORING the slicers, so for example in the table above the overall average would be 3.67. If the slicer for Dim1 is set to "type2", I want the measure for the overall average to recalculate and output 4.

Any combination of CALCULATE, ALLEXCEPT, ALL, FILTER... and so on that I've tried so far either only returned 3.67 all of the time, ignoring the slicers or just returned the average of the individual rows.

Any suggestions? Thanks in advance!

[amitchandak · Accepted solution]

@_ds3000_ ,

Respect filter

calculate(Average(Table[Conversions]) , allselected(Table))

do not respect filter

calculate(Average(Table[Conversions]) , all(Table))

[_ds3000_]

Hey @amitchandak many thanks for your answer. this does in fact seem to work. no idea what I did wrong earlier.