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.
I have a measure which correctly-ish calculates the average of "Story Points Delivered" ([SPDelivered]) over the last three sprints.
Velocity =
VAR esprint = MAX('dim iterations'[SprintNumber])-3
VAR lsprint = MAX('dim iterations'[SprintNumber])-1
RETURN
CALCULATE(SUM('fact workitems'[SPDelivered])/3,
FILTER('dim iterations','dim iterations'[SprintNumber]>=esprint && 'dim iterations'[SprintNumber]<=lsprint),
ALL('dim iterations'[SprintNumber]))
I can see the measure displaying as I want it to in a table, when grouped by AreaName or TeamName (from related tables), but not when I add the SprintNumber from a different related table, which I have used in the measure.
The same happens if I display in a column visual. Works fone for TeamName and AreaName, but shows nothing when I want to display it over SprintNumber:
The Data Model looks like this:
I have uploaded the pbix file here
Solved! Go to Solution.
@Anonymous , Try like
Velocity =
VAR esprint = MAX('dim iterations'[SprintNumber])-3
VAR lsprint = MAX('dim iterations'[SprintNumber])-1
RETURN
CALCULATE(SUM('fact workitems'[SPDelivered])/3,
FILTER(all('dim iterations'),'dim iterations'[SprintNumber]>=esprint && 'dim iterations'[SprintNumber]<=lsprint),
)
That works! Thank you very much kind sir.
@Anonymous , Try like
Velocity =
VAR esprint = MAX('dim iterations'[SprintNumber])-3
VAR lsprint = MAX('dim iterations'[SprintNumber])-1
RETURN
CALCULATE(SUM('fact workitems'[SPDelivered])/3,
FILTER(all('dim iterations'),'dim iterations'[SprintNumber]>=esprint && 'dim iterations'[SprintNumber]<=lsprint),
)
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 |
---|---|
114 | |
99 | |
83 | |
70 | |
61 |
User | Count |
---|---|
149 | |
114 | |
107 | |
89 | |
67 |