unaspected result of count aggragation

[madami]

I have 4 tables, rmas 1-1 rma_managers 1-* rma_managers_product *-1 products. Relationship are configured as follow image shows:

I want to count how many rmaID there are for any productModel splitted per year.

I put products.productModel in rows, rmas.rmaDate in Columns and count of rmas.rmaID in values. What I get is not the count of rmaID per year and model, but in every ros I get the total count of rmaI per year.

What am I doing wrong and what can I do to solve this?

Thanks

[v-sihou-msft · Accepted solution]

@madami

In this scenario, you should change the Cross filter direction between rma_managers table and rma_managers_product table into "Both"

Then the "Count of rmaID" can be sliced by Product properly.

Regards,

[madami]

Thanks @v-sihou-msft, now it works as expected.

[vanessafvg]

@madami its because of your bidirectional relationships, what is your measure code?

[madami]

@vanessafvg I dont use misure, I just put the column in Values and select count as aggragation. Should I create a misure?