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.

Ashish_Mathur's avatar
Ashish_Mathur
Super User
6 years ago

Hi,

Share a dataset and show the expected result.