Forum Discussion
Percentages on Subtotal
Hi, I am triying to calculate percentages based on Subtotal percentage(as 100%), can please help how to manage with DAX to achieve this. For example I copied from excel and wanted to achieve same i...
Hi Pat,
Thank you, I think I am missing something here, we ar actually getting counts at report level (by selecting on values) but we do not have separate measure for counts. Is it something I should create? please advise. below the core data for example.
| ID | Segment | Level |
| 70012 | Balance | Load |
| 70015 | Roles | Load |
| 70035 | Balance | Load |
| 70045 | SBMT | Load |
| 70047 | Roles | Load |
| 70049 | Health | Load |
| 70062 | MGMT | Load |
| 70065 | Health | Load |
| 70071 | MGMT | Load |
| 70103 | Roles | Load |
| 70111 | SBMT | Load |
| 70117 | MGMT | Load |
| 70118 | Health | Load |
| 70127 | Roles | Load |
| 70141 | Roles | Load |
| 70150 | Roles | Load |
| 70010 | Roles | Proofing |
| 70016 | SBMT | Proofing |
| 70022 | Roles | Proofing |
| 70023 | SBMT | Proofing |
| 70028 | SBMT | Proofing |
| 70048 | SBMT | Proofing |
| 70069 | SBMT | Proofing |
| 70080 | Roles | Proofing |
| 70089 | MGMT | Proofing |
| 70096 | Roles | Proofing |
| 70105 | Roles | Proofing |
| 70112 | Roles | Proofing |
and I am trying to achieve percentages like below
| Level | Segment | Count | Percentage |
| Load | Balance | 2 | 13% |
| Load | Health | 3 | 19% |
| Load | MGMT | 3 | 19% |
| Load | Roles | 6 | 38% |
| Load | SBMT | 2 | 13% |
| Proofing | MGMT | 1 | 8% |
| Proofing | Roles | 6 | 50% |
| Proofing | SBMT | 5 | 42% |
Just wanted to add, in above table for first row percentage calculation would be like (2/16) rounded to near number following to next row like (3/16) rounded to near number.