DAX for checking quantities

macfuller

Board Regular
Joined
Apr 30, 2014
Messages
242
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.
 

Forum statistics

Threads
1,077,822
Messages
5,336,564
Members
399,088
Latest member
Swindlestikz

Some videos you may like

This Week's Hot Topics

Top