Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn 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.
User | Count |
---|---|
92 | |
86 | |
78 | |
72 | |
65 |
User | Count |
---|---|
115 | |
107 | |
85 | |
65 | |
64 |