topic Re: Help filter visual table with average value in DAX Commands and Tips

Help filter visual table with average value

DannyHernandez — Fri, 17 Jun 2022 22:12:31 GMT

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:

Re: Help filter visual table with average value

v-yalanwu-msft — Mon, 20 Jun 2022 01:54:42 GMT

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.

Re: Help filter visual table with average value

DannyHernandez — Mon, 20 Jun 2022 19:47:35 GMT

AVERAGE MEASUREMENT DOES NOT WORK WHEN FILTERS ARE APPLIED

Re: Help filter visual table with average value

v-yalanwu-msft — Tue, 21 Jun 2022 01:53:57 GMT

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.