Average of Count of Items from Relationship table

[yogeshk77]

Hi,

I need to find average of Count of items that refers to one many relationship child table.

I have following tables & their relations

Parent Stories table

Has one to many relation with Child table

Notice How PR ID repeats for a different Stories

Now, I need a measure (Say "Measure Avg PR Count"), that'll give me the Average number of PRs against each Story Points, like below -

Can someone please help ?

[johnt75 · Accepted solution]

You can try the below measure

Avg num PRs =
AVERAGEX (
    VALUES ( 'Stories'[Story ID] ),
    COUNTROWS ( RELATEDTABLE ( 'PRs Stories' ) )
)

This assumes that a PR can occur in multiple stories but can only appear once per story.

Put this in a visual with the story points column and I think it should work.