Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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?
Solved! Go to Solution.
Yes I did. Relationship is not problem. It fixed by the way. I have to use Actor No from Casting table.
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsYes I did. Relationship is not problem. It fixed by the way. I have to use Actor No from Casting table.