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...
lbendlin
Super User
Super UserPlease provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).
Do not include sensitive information or anything not related to the issue or question.
If you are unsure how to upload data please refer to https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-p/963216
Please show the expected outcome based on the sample data you provided.
Want faster answers? https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523
| 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 |