Simple relationship

[setis]

Dear all,

I know this is super basic, but I don't really understand why it's not working. 

The model looks like this:

I need to calculate the nr of activities per Fee Type.

Since both tables are related to cases and being Cases[CaseID] unique values, I don't undestand how it wouldn't work on a simple table:

The file is here in case it helps https://drive.google.com/file/d/1b4qD8X9NHPZPRAOzIT9eknvRLNDu3CeU/view?usp=sharing 

PS. I'm guessing tha the issue is that Cases can have more than one fee type.

Thanks in advance

[v-frfei-msft · Accepted solution]

Hi @setis ,

Actually, it is related to the direction of relationship. Here I changed the direction from single to both between Cases and Fees. 

Regards,

Frank