Forum Discussion
How To Create A Measure That is Group And Ignores Filters
Super Userin your measure use REMOVEFILTERS(<player>)
This did not work, it just gives an un-rounded version of the average moves column.
- lbendlin
Please 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/1447523Player 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: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
Your sample data only includes a single day,