Matrix - Sorting Female and Male based on Movie they been cast to.

[k31453]

Hi,

I have following tables:

ACTOR TABLE:

CAST TABLE:

MOVIE TABLE:

What I want is something like this:

Basically I want to display number of actors in each movie by Gender. I attempted using Matrix. However, the number i am looking at is incorrect. How can I solve the problem. Should I use New measure? 

[Anonymous]

Hello @k31453 

Could you please share me dax expression for this (sorting female and amle )

[MFelix]

Hi @k31453,

Do you have all your relationships correct? And did you select the correct summatize function for M/F you need the count.

Regards
Mfelix

[k31453 · Accepted solution]

Yes I did. Relationship is not problem. It fixed by the way. I have to use Actor No from Casting table.