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.
Hello,
I am trying to make a table with the Yield rate(which is total enrolled divided by total applied) by year. Is there a way to do it? A formula?
My Data looks like this:
Solved! Go to Solution.
Create a Measure (call it anything that works for you). Since you want % at the ROW level, the formula doesn't have to take into account any filtering or grouping...
Measure = SUM(Table1[Admitted]) / SUM(Table1[Applied])
Raw Data I entered based on your screen shot & Matrix with Rows = R&E, Columns = Year, & Values = your measure
Proud to give back to the community!
Thank You!
It looks like a simple request, but depending on how you want to display the data, it coudl be more complciated. I'm assuming you have mutliple years of data not displayed in your sample? Do you want the Yeild by line to the right of the data, or a total at the bottom for all 'Race and Ethnicity' by year?
Can you mock up your desired output?
FOrrest
Proud to give back to the community!
Thank You!
I was hoping for something like this:
Create a Measure (call it anything that works for you). Since you want % at the ROW level, the formula doesn't have to take into account any filtering or grouping...
Measure = SUM(Table1[Admitted]) / SUM(Table1[Applied])
Raw Data I entered based on your screen shot & Matrix with Rows = R&E, Columns = Year, & Values = your measure
Proud to give back to the community!
Thank You!
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 | |
82 | |
66 | |
58 |
User | Count |
---|---|
151 | |
121 | |
104 | |
87 | |
67 |