Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

exclude rows that dont have some entry

Hello.    I have two tables: order lines and master data of product. I made a lookup values to know the master data of each product (weight, height, length, etc)   I have the following example: ...
@get help
  • AlB's avatar
    AlB
    5 years ago

    Hi Anonymous 

    Exclude =
IF (
    "No"
        IN CALCULATETABLE (
            DISTINCT ( Table1[Master Data of Product] ),
            ALLEXCEPT ( Table1, Table1[OrderNo] )
        ),
    "Yes",
    "No"
)

     

    		 Please accept the solution when done and consider giving a thumbs up if posts are helpful. 

    Contact me privately for support with any larger-scale BI needs, tutoring, etc.

     

AlB's avatar
AlB
Icon for Community Champion rankCommunity Champion
5 years ago

Hi Anonymous 

Exclude =
IF (
    "No"
        IN CALCULATETABLE (
            DISTINCT ( Table1[Master Data of Product] ),
            ALLEXCEPT ( Table1, Table1[OrderNo] )
        ),
    "Yes",
    "No"
)

 

 Please accept the solution when done and consider giving a thumbs up if posts are helpful. 

Contact me privately for support with any larger-scale BI needs, tutoring, etc.

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Thank you for your reply. 

     

    I'm having the error that the sintax for "IN" is incorrect. Have you tried this formula?  It is the first time that i use an IN function. 

     

    Thank you.