Sum based on specific grouping condition

bmk 

So if you add 01B or 02B to a card visual, they work.

However, if you try to add them to the table visual, you get the following error:

"SummarizeColumns() and AddMissingItems() may not be used in this context."

That's annoying.

The following link provides guidance that we should replace SUMMARIZECOLUMNS with ADDCOLUMNS+SUMMARIZE.

https://community.powerbi.com/t5/Desktop/Issue-with-Bar-chart-SummarizeColumns-and-AddMissingItems-may/m-p/1145554#M519845

So I have modified the code here in 01C & 02C.

As a result, these now work correctly within the table visual, as shown.

Regards,

Nathan