Only display values that are greater than the average of column

[crmart1n_mx]

Hi Everyone,

I'm working on a report and am trying to create a chart; where the data displayed is filtered. Here's what my data looks like in the visual:

And here's what i'm looking to accomplish:

• The column AvgAHT - I'd like to calculate the overall average of values from that column and then in this visual, only display those which are higher than that average (essentially an outlier report for those who exceeded the department average)

I tried playing around with some filters, but figured i'd see if anyone knew a more simple way to do this.

Appreciate any help in advance!

[Anonymous · Accepted solution]

Hi  @crmart1n_mx ,

Here are the steps you can follow：

1. Create measure.

Flag =
var _avgall=AVERAGEX(ALL('Table'),[AvgAHT])
return
IF(
    MAX('Table'[AvgAHT]) >= _avgall,1,0)

2. Place [Flag]in Filters, set is=1, apply filter.

3. Result:

Best Regards,

Liu Yang

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

[Ashish_Mathur]

Hi,

Share the download link of the PBI file.

[amitchandak]

@crmart1n_mx , Use this measure as visual level filter

Var _1 = calculare([AHT], allselected())

return

Averagex(filter(Summarize(Fact, Fact[Name], Date[Month]), [AHT]>_1), [AHT])

CHekc in visual level filter, that this is not blank