Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi,
Data is as below:
QB Name | Picks Thrown |
Tom Brady | 0 |
Tom Brady | 0 |
Tom Brady | 1 |
Tom Brady | 2 |
Tom Brady | 4 |
Tom Brady | 3 |
Tom Brady | 1 |
Tom Brady | 3 |
Tom Brady | 2 |
Tom Brady | 1 |
Tom Brady | 0 |
Tom Brady | 0 |
Tom Brady | 2 |
Tom Brady | 1 |
Tom Brady | 0 |
Nathan Peterman | 4 |
Nathan Peterman | 3 |
Nathan Peterman | 4 |
Nathan Peterman | 0 |
Nathan Peterman | 1 |
Nathan Peterman | 1 |
Nathan Peterman | 4 |
Nathan Peterman | 3 |
Nathan Peterman | 3 |
Nathan Peterman | 4 |
Nathan Peterman | 3 |
Nathan Peterman | 4 |
Nathan Peterman | 1 |
Nathan Peterman | 1 |
Nathan Peterman | 0 |
What I'm wanting to do is plot a graph that can show me the number of games where a QB has thrown at most 0, 1, 2 etc interceptions. So I count the number of games with a simple measure Games Played = countrows(Table1), and then I'm trying the following measure:
Games played with n or less picks = calculate([Games Played], filter(allselected(Table1),Table1[Picks Thrown]<=max(Table1[Picks Thrown])))
This works perfectly:
Now if I want to filter just Peterman's games, him not having a two-interception game is giving unwanted results. If I select his name from the other visual, this happens:
and if I hover over the value for two interceptions, it's calculating the measure to give 2. If I add a slicer instead, rather than evaluating the measure "incorrectly", it doesn't evaluate the measure at all and just completes a line directly from x-axis values 1 and 3 to y-axis values 6 and 10. Does anyone have any ideas how I can reword the cumulative measure so that it evaluates Peterman as having six games with two or less interceptions?
Solved! Go to Solution.
HI @jthomson -
I was able to get it to work by doing the following:
Create a new table for all of the values in "Picks Thrown"
IntNums = VALUES(Ints[Picks Thrown])
Join to the Interceptions table
Modified the measure to filter on IntNums table
Games played with n or less picks = CALCULATE ( [Games Played], FILTER ( ALLSELECTED ( IntNums ), IntNums[Picks Thrown] <= MAX ( IntNums[Picks Thrown] ) ) )
Use IntNums as the axis for the bar/line chart (and for the rows on the tables)
Hope this helps
David
HI @jthomson -
I was able to get it to work by doing the following:
Create a new table for all of the values in "Picks Thrown"
IntNums = VALUES(Ints[Picks Thrown])
Join to the Interceptions table
Modified the measure to filter on IntNums table
Games played with n or less picks = CALCULATE ( [Games Played], FILTER ( ALLSELECTED ( IntNums ), IntNums[Picks Thrown] <= MAX ( IntNums[Picks Thrown] ) ) )
Use IntNums as the axis for the bar/line chart (and for the rows on the tables)
Hope this helps
David
Cheers, tweaked it a bit to use generateseries between 0 and the max value of the data, but the concept of using a separate table as the axis is working fine
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
110 | |
100 | |
80 | |
64 | |
58 |
User | Count |
---|---|
148 | |
111 | |
94 | |
84 | |
67 |