Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
Anonymous
Not applicable

Measure won't display in a Visual when adding a grouping used in the measure

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.

pchmurzynskivf_0-1669369811296.pngpchmurzynskivf_1-1669369834191.png

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:

pchmurzynskivf_0-1669370702247.png

pchmurzynskivf_1-1669370725722.png

The Data Model looks like this:

data model.jpg
I have uploaded the pbix file here

1 ACCEPTED SOLUTION
amitchandak
Super User
Super User

@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),
)

View solution in original post

2 REPLIES 2
Anonymous
Not applicable

That works! Thank you very much kind sir.

amitchandak
Super User
Super User

@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),
)

Helpful resources

Announcements
LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.