How to do total sum based on the (Group by)column name

[Anonymous]

How to acheive the desired output. And i want to add a bold line after every bbcode. that is for 2 A's one line and then B line similarlly.

[v-frfei-msft]

Hi @Anonymous,

Based on my test, it is not possbile to achieve your goal currently. Howvere we can create measure to work around.

Measure = CALCULATE(SUM(Table1[sales]),ALLEXCEPT(Table1,Table1[bbcode]))

Also please find the pbix as attached.

Regards,

Frank

[v-frfei-msft]

Hi @Anonymous,

Does that make sense? If so, kindly mark my answer as a solution to close the case.

Regards,
Frank