Forum Discussion
How to do total sum based on the (Group by)column name
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.
2 Replies
v-frfei-msftCommunity Support
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