Problem with filter

[learner03]

I need below view-

1) First table with the warehouse zone(A,B,C) and then the total of location that have 0 quantity, then the total seperated into Bulk 1.2, bulk 1.7, bulk half and bulk skid. This is to know the at granular level which Bin Location is empty.

2) on clicking the number , for example if user clicks cordinate-warehouse A with Bulk 1.2, then the Location table should show those locations that are empty in warehouse  and has bin type as bulk 1.2.

I couls achieve by total bin but not by bulk 1.2, bulk 1.7, bulk half and bulk skid.

link for the pbix attached-https://drive.google.com/drive/folders/1PRMeI7Ph_MK1T20YOdVZVhLbsyghyjhB?usp=sharing 

https://drive.google.com/drive/folders/1PRMeI7Ph_MK1T20YOdVZVhLbsyghyjhB?usp=sharing

[MFelix · Accepted solution]

Hi @learner03 ,

Create a Bulk Table with the folliwng data:

Bulk

Bulk 1.2
Bulk 1.7
Bulk Half
Bulk Skid

Add the following measure:

Bulks Measure =
CALCULATE (
    COUNTROWS (
        FILTER (
            Bins,
            (
                IF (
                    Bins[Sum TOTAL QTY] = 0,
                    AND (
                        ISBLANK ( Bins[Sum TOTAL QTY] ),
                        Bins[BinType] = SELECTEDVALUE ( Bulks[Bulk] )
                    )
                )
            )
        )
    )
)

This will replace the other 4 measures you created now add a matrix with the following setup:

• Rows: Wharehouse
• Columns: Bulk
• Values: Bulks Measure

Now on the location add the Bulks measure has a filter and set has is not blank result below and attach.: