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.
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.
Does that make sense? If so, kindly mark my answer as a solution to close the case.
Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.
We spoke with Power BI Super User, Greg Deckler, about his charity work
Continue your learning in our online communities.