Relationships and except

[Anonymous]

Hello,

I am fairly new and not sure where I am messing this up.

At the moment my report is fairly simple with 2 tables 1 inventory and the other product, I have use except funtion to create a new table of any missing product on the inventory.

On the report a lot of visualization cross filter when I select a brand, except those on the except table at the moment this has a 1 to 1 relationship with cross filter both directions to the product table. I want to know how I can select a brant and show me the products of the brand missing.

[Icey · Accepted solution]

Hi @Anonymous ,

Is this what you want?

Missing Product = 
IF (
    CALCULATE (
        COUNTROWS ( inventory ),
        FILTER ( inventory, inventory[Product] = 'product'[product] )
    ) = 0,
    'product'[product]
)

Best Regards,

Icey

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous]

Hello @Icey 

This does work, I am still curious why my approach of the new table and the relationships didn't work but I will take this wisdom you provide, thanks!

[Ashish_Mathur]

Hi,

Share a dataset and show the expected result.