Sub unit Total

[MSuser5]

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

[Anonymous · Accepted solution]

Hello @MSuser5 ,

Try using following DAX:

ALLSELECTED_measure = CALCULATE([Count]),ALLSELECTED([Sub_Unit])

Thanks

If this helps, mark this as a solution!!

[Dhairya · Accepted solution]

Heu @MSuser5 

Input:

Please create the following measure

Sub_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!

[MSuser5]

Thanks its working as expected

[Anonymous · Accepted solution]

Hello @MSuser5 ,

Try using following DAX:

ALLSELECTED_measure = CALCULATE([Count]),ALLSELECTED([Sub_Unit])

Thanks

If this helps, mark this as a solution!!

[rubayatyasmin]

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. 

[MSuser5]

Hi @rubayatyasmin ,

Sub_unit Total -  i need to create in measure

[rubayatyasmin]

so, you can not split the column? it is your requirement?