Customized Subgroup Aggregation

[jkim62]

greetings.

i am moving ssrs reports to power bi, and i got some problem with matix. 

i have data looks like far below

here's the summarized order count. 

OrderType	OrderCount
A	13
B	26
C	14
D	9
E	13

and trying to create a matrix looks like this.

OrderType	Count
A+B+C+D	62
A	13
B+C+D	49
C+D	23
D	9
E	13

it was easily done in ssrs creating custom grouping but pbi doesn't seem to support that feature. 😞

i tried to attach a couple of files but this message board doesn't seem to support that feature either. 😞

any help will be appreciated. 

thank you very much.

/k

--

data

OrderType	OrderID
A	3
A	7
A	11
A	12
A	20
A	24
A	27
A	32
A	38
A	44
A	50
A	53
A	60
B	68
B	73
B	80
B	88
B	89
B	98
B	107
B	114
B	124
B	125
B	135
B	141
B	142
B	148
B	152
B	163
B	164
B	174
B	181
B	191
B	202
B	207
B	216
B	223
B	225
B	231
C	239
C	240
C	245
C	254
C	265
C	276
C	283
C	288
C	295
C	305
C	308
C	309
C	313
C	317
D	325
D	329
D	336
D	339
D	341
D	345
D	353
D	362
D	369
E	377
E	387
E	391
E	400
E	408
E	413
E	414
E	423
E	433
E	442
E	443
E	447
E	453

[v-piga-msft · Accepted solution]

Hi @jkim62 ,

As parry2k suggested, we could create the custom group to achieve that similar output to that in ssrs.

If you have solved the problem, please always accept the replies making sense as solution to your question so that people who may have the same question can get the solution directly.

If you still need help, feel free to ask.

Best  Regards,

Cherry

[parry2k]

@jkim62 yes you need to create custom grouping here as well, is custom grouping/levels always going to be what you mentioned