Need help setting up a logistics visual

Anonymous

Hi Robin,

That's OK. I found a solution. Please reference this file: https://1drv.ms/u/s!ArTqPk2pu-BkgRhSiy4U2C9zaXVG

1. Create a new table "WH".

WH =
VALUES ( 'Table1'[WareHouse Number] )

2. Establish relationship.

3. Create a measure.

FinalMeasure =
VAR selectedWH =
    IF (
        HASONEVALUE ( WH[WareHouse Number] ),
        VALUES ( WH[WareHouse Number] ),
        BLANK ()
    )
VAR selectedWHvk2 =
    CALCULATETABLE (
        VALUES ( Table1[Item] ),
        FILTER (
            ALL ( 'Table1' ),
            'Table1'[Item Class] = 2
                && 'Table1'[WareHouse Number] = selectedWH
        )
    )
RETURN
    CALCULATE (
        IF (
            MIN ( 'Table1'[Item] ) IN selectedWHvk2
                && MIN ( 'Table1'[Item Class] ) = 1,
            1,
            0
        ),
        ALL ( WH )
    )

4. Create several visuals.

5. Filter the result. (Visual level filter)

Note: 1. The slicers are from different tables. Don't mix up.

2. All the columns are needed in the visual as the picture showed. 

Best Regards!

Dale