Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Relationships and except

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...
Need Help
  • Icey's avatar
    Icey
    6 years ago

    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.

Icey's avatar
Icey
Community Support
6 years ago

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's avatar
Anonymous
Not applicable
6 years ago

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!