Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
I need to calculate a Sex ratio ([male/female]*100) for every year.
I read on the forum to make 3 measure e.g F, M and use sexratio=M/F.
I am having problems calculating the measures F and M, which the numbers shown in the columns Female and male.
Original Excel input
Unpivotted file
In Power BI
Solved! Go to Solution.
Hi,
Do not drag Sex to the column area section. Just drag years to the row area section and then write the 3 measures that i shared with you in my earlier post.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
110 | |
94 | |
80 | |
67 | |
59 |
User | Count |
---|---|
150 | |
119 | |
104 | |
87 | |
67 |