Forum Discussion
Solved
Help filter visual table with average value
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:
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.
3 Replies
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.AVERAGE MEASUREMENT DOES NOT WORK WHEN FILTERS ARE APPLIED
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.
