Forum Discussion
Sub unit Total
Hi All,
I have data sub unit and each month and i'm created category within/ Beyond SLA level now i want to calculate Total of sub unit level
kindly hlep me on this.
| Sub_Unit | Count | Value | Sub_unit Total |
| Export | 10 | Beyond SLA | 261 |
| Export | 251 | Within SLA | 261 |
| Import | 97 | Beyond SLA | 488 |
| Import | 391 | Within SLA | 488 |
| Process | 74 | Beyond SLA | 311 |
| Process | 237 | Within SLA | 311 |
| Live | 68 | Beyond SLA | 497 |
| Live | 429 | Within SLA | 497 |
| Create | 669 | Beyond SLA | 1912 |
| Create | 1243 | Within SLA | 1912 |
| Locked | 28 | Beyond SLA | 465 |
| Locked | 437 | Within SLA | 465 |
| Release | 182 | Beyond SLA | 456 |
| Release | 274 | Within SLA | 456 |
| Total | 4390 | 4390 |
i want to create like last column sub unit total.
Thanks,
MS
Hello MSuser5 ,
Try using following DAX:
ALLSELECTED_measure = CALCULATE([Count]),ALLSELECTED([Sub_Unit])ThanksIf this helps, mark this as a solution!!Heu MSuser5
Input:
Please create the following measureSub_unit Total = CALCULATE(SUM(TableA[Count]), ALLEXCEPT(TableA,TableA[Sub_Unit]))
And Plot the table and you will get the expected output:
If this helps you then please mark my solution as accepted so that others can find it quickly when they face the similar issue. Thank you!
6 Replies
Hi, MSuser5
From the picture, I get that you have three columns right? and last column has text and number mixed and you want to sum the numbers.
here is the suggestation.
1. go to power query.
2. split the last column
here is the documentation for you. https://learn.microsoft.com/en-us/power-query/split-columns-delimiter
after split, you will have 2 columns. rename with your own choise.
sum it up or visualize it in a table.
so, you can not split the column? it is your requirement?
Hello MSuser5 ,
Try using following DAX:
ALLSELECTED_measure = CALCULATE([Count]),ALLSELECTED([Sub_Unit])ThanksIf this helps, mark this as a solution!!Heu MSuser5
Input:
Please create the following measureSub_unit Total = CALCULATE(SUM(TableA[Count]), ALLEXCEPT(TableA,TableA[Sub_Unit]))
And Plot the table and you will get the expected output:
If this helps you then please mark my solution as accepted so that others can find it quickly when they face the similar issue. Thank you!
Thanks its working as expected
