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 have tried a few different formulas, but I am not able to just get the row percentage for each row. The end goal is to have the two rows displayed in a pie chart. The problem I am running into is that the percentage that it gives me is a total of the two rows, instead of dividing one row by the other. I would appreciate any help!
Thank you!
Attached are the two rows that I would like to get percentages for.
Solved! Go to Solution.
Hi @Anonymous
Create measures
Measure = CALCULATE(SUM(Table1[Column1]),FILTER(ALL(Table1),[VDC Goal]="Current Employees")) Measure 2 = CALCULATE(SUM(Table1[Column1]),FILTER(ALL(Table1),[VDC Goal]="Employee Hire Goal")) Measure 3 = IF(MAX(Table1[VDC Goal])="Employee Hire Goal",1,[Measure]/[Measure 2])
Best Regards
Maggie
Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @Anonymous
Create measures
Measure = CALCULATE(SUM(Table1[Column1]),FILTER(ALL(Table1),[VDC Goal]="Current Employees")) Measure 2 = CALCULATE(SUM(Table1[Column1]),FILTER(ALL(Table1),[VDC Goal]="Employee Hire Goal")) Measure 3 = IF(MAX(Table1[VDC Goal])="Employee Hire Goal",1,[Measure]/[Measure 2])
Best Regards
Maggie
Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
In the Fields area, click the little drop down next to the column and choose "Show As | Percentage of row" or Percent of total
I only have "Percentage of Grand Total" on the drop down menu.
Thank you for the reply!
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 |