Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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),
)
User | Count |
---|---|
93 | |
84 | |
78 | |
75 | |
66 |
User | Count |
---|---|
115 | |
105 | |
93 | |
65 | |
60 |