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

Anonymous 

Should work. You've probably done something differently. See it in the attached file.

 

 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.