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.
...
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.
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.