Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric 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 |
---|---|
87 | |
84 | |
70 | |
62 | |
56 |
User | Count |
---|---|
137 | |
110 | |
92 | |
84 | |
69 |