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% |
Appreciate, thank you so much.
You are welcome.
This is the second time that I find a solution proposed by you, but you don't put the resolution here. The .pbi file is no longer available for download. It would be much better to put it step by step here, wouldn't it?
I do not have the file. Post your data, explain the question and show the expected result.
