I scrape the wonderful data at Brickset for showing basic DAX concepts, but I'm a bit stumped on a seemingly simple question someone posed. If I have Lego kits A, B, and C, can I create just a measure to tell if I have enough of the correct bricks to build kit D? I can use a helper column in the table, but that's specific to the particular kit combination I'm looking at rather than being something generic.
All the kit info is loaded into a single table. To determine if I have enough bricks I have to go line by line in kit D to add up all the brick quantities of each part number in kits A-C and see if that quantity >= kit D requirements. If a single line is FALSE then the answer is no. I suspect it's some sort of ADDCOLUMN magic but I can't get it right.
All the kit info is loaded into a single table. To determine if I have enough bricks I have to go line by line in kit D to add up all the brick quantities of each part number in kits A-C and see if that quantity >= kit D requirements. If a single line is FALSE then the answer is no. I suspect it's some sort of ADDCOLUMN magic but I can't get it right.