Count Rows from Related Table with Filters

[Anonymous]

Been away from PowerBI for a few years and trying to get back into it but having a challenge with a relatively easy calculation.

I have two tables "Person" and "History" with a one-to-many relationship via the "PersonID".  I've been unsucessful in calculating the percent of person who have a status of "H" from the "Person" table.  I've used the below function with a filter but that returns the total count from the table, not just the realated records from "History".

This is what I've used and now I'm thinking I need to somehow set 'Person'[PersonID] = 'History'[PersonID]

COUNTROWS(FILTER(Person, Person[Status]="Y"))

Not sure why the realationship in the model is not restricting the counts but anyone's help here would be greatly appreciated.

Thanks in advance!

Tim

[Anonymous]

I finally got something working but it is likely not the most efficient.  I know I calculated various percentages from related tables for Cards in the past and don't remember doing them this way.  Here is the DAX I used:

MEASURE =

CALCULATE(

    DIVIDE(

COUNTROWS(FILTER('PERSON', CONTAINS(HISTORY,[PersonID], 'PERSON'[PersonId]) && PERSON[Indicator]="Y"))

,

COUNTROWS(FILTER('PERSON', CONTAINS(HISTORY,[PersonID], 'PERSON'[PersonId])

))))

[Ashish_Mathur]

Hi,

Share data in a format that can be pasted in an MS Excel file and show the expected result clearly.