Help filter visual table with average value

[DannyHernandez]

I have a table and a bar graph in which I have values ​​that are shown with a line the average value.
The average value is 73.3, I need to display a table with only the values ​​below the average.

the average line has the following configuration:

Converted to table it looks like this:

 It should be displayed as follows:

[v-yalanwu-msft · Accepted solution]

Hi,  @DannyHernandez ;

If you have a slicer , you could change the measure to this.

flag = IF(SUM('Table'[KILOMETRAJE TOTAL DIARIO])<=AVERAGEX(ALLSELECTED('Table'),[KILOMETRAJE TOTAL DIARIO]),1,0)

Best Regards,
Community Support Team _ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[v-yalanwu-msft]

Hi, @DannyHernandez ;

You could create a flag measure.

flag = IF(SUM('Table'[KILOMETRAJE TOTAL DIARIO])<=AVERAGEX(ALL('Table'),[KILOMETRAJE TOTAL DIARIO]),1,0)

then apply it into filter.

The final show:

Best Regards,
Community Support Team _ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[DannyHernandez]

AVERAGE MEASUREMENT DOES NOT WORK WHEN FILTERS ARE APPLIED