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 Everyone,
I am having trouble creating a column that can accurately represent what I am trying to present.
The above matrix is what I currently have in Power BI. I am trying to make another column here that will be a percentage column. I need it to be the percentage of "yes" out of the "total."
I cant just use a regular measure, because I want it to calculate for each column. On the back end, Im pullin this info from two data columns. A "Job" column that lists the job to the left, and a "Retire Eligible/5yrs" column that tells me the yes or the no.
This is the DAX measure/column that I was trying, but it doesnt seem to be correct:
As extra information, I just made the "help column" as a column where all cells are equal to 1, since I wasnt able to sum the "job" column as it is non-numerical.
Is there a simple way that I am missing that I can get this to work?
Thank you!
Solved! Go to Solution.
Hi @Anonymous
You may create measures like below.For example:
Yes = CALCULATE(COUNT(Table2[Job]),FILTER(Table2,Table2[Eligible]="Yes"))
Percent = [Yes]/CALCULATE(COUNT(Table2[Job]))
Regards,
Hi @Anonymous
You may create measures like below.For example:
Yes = CALCULATE(COUNT(Table2[Job]),FILTER(Table2,Table2[Eligible]="Yes"))
Percent = [Yes]/CALCULATE(COUNT(Table2[Job]))
Regards,
This seems to work! 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 |
---|---|
113 | |
99 | |
80 | |
70 | |
60 |
User | Count |
---|---|
149 | |
114 | |
107 | |
89 | |
67 |