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

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.

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
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.