Group by? Rollup? Summarize?

[MEGtheDEV]

Hello All -

I am not new to this but am totally stumped by this request. Any help would be tremendously appreciated.

I have a table with several columns that are all feeding to create a "score" by row B - the detailed level row of data which rolls up into row A - where all the "score" really counts. I need to be able to identify the uncounted rows in the detail that haven't been identified in the roll up column. 

Example of desired result:

A	B	Score	Result
ABC	123	1	1
ABC	456	0	1
DEF	123	0	0
DEF	456	0	0
GHI	123	1	1
GHI	456	1	1
JKL	123	0	0

Note: I cannot use "Group By" in Power Query because the score lives in DAX created columns.

Thanks!

[VijayP]

@MEGtheDEV 

Try using Summarize