Forum Discussion
How To Create A Measure That is Group And Ignores Filters
Hi! So basically i need to create a measure that is grouped and does not get affected a row filter. Lets say i have a table: Player Average Moves Per Day Team Ted 7 Red Bill...
| Player | Moves | Team | Date |
| Tim | Left | Red | 1/1/2001 |
| Tim | Right | Red | 1/1/2001 |
| Tim | Left | Red | 1/1/2001 |
| Tim | Down | Red | 1/1/2001 |
| Mark | Up | Blue | 1/1/2001 |
| Mark | Right | Blue | 1/1/2001 |
| Mark | Up | Blue | 1/1/2001 |
| Mark | Up | Blue | 1/1/2001 |
| Joe | Left | Blue | 1/1/2001 |
| Joe | Left | Blue | 1/1/2001 |
| Joe | Right | Blue | 1/1/2001 |
| Joe | Right | Blue | 1/1/2001 |
| Joe | Right | Blue | 1/1/2001 |
| Joe | Right | Blue | 1/1/2001 |
| Bob | Down | Red | 1/1/2001 |
| Bob | Up | Red | 1/1/2001 |
| Bob | Up | Red | 1/1/2001 |
| Bob | Right | Red | 1/1/2001 |
The "Avg Moves Per Day" column comes from a measure:
CALCULATE(
AVERAGEX(VALUES(Date, Moves),
FILTER(Moves>0))
The Moves measure used in the above measure is a count of moves. So the ends result gives me the average moves by player per day when putting player and that measure in a table.
I am trying to do something similar for Team where it gives me Average Moves Per Team like so:
The Moves measure used in the above measure is a count of moves. So the ends result gives me the average moves by player per day when putting player and that measure in a table.
I am trying to do something similar for Team where it gives me Average Moves Per Team like so:
| Player | Avg Moves/Day | Team | Avg Team Moves/Day |
| Tim | 4 | Red | 4 |
| Mark | 4 | Blue | 5 |
| Joe | 6 | Blue | 5 |
| Bob | 4 | Red | 4 |
lbendlin
Super User
Super UserYour sample data only includes a single day,