Forum Discussion

setis's avatar
setis
Post Partisan
7 years ago
Solved

Simple relationship

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

 

Need Help

1 Reply

  • v-frfei-msft's avatar
    v-frfei-msft
    Community Support
    7 years ago

    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