Forum Discussion

1001's avatar
1001
Resolver II
3 years ago

Removing Blank from s Distinct function Table.

Hi Guys, I've created a table of distinct values from another table. However, I have a blank cell that's carried across. The blank cell is preventing me from creating a one to many relationship to th...
Need Help
Ahmedx's avatar
Ahmedx
Super User
3 years ago
SubProduct Grp = FILTER(DISTINCT(Masterdata[Sub Category]),[Sub Category]<>BLANK())
  • 1001's avatar
    1001
    Resolver II
    3 years ago

    Hi Ahmedx, thanks for replying.

    I ended up, in the Query editor, referencing my main table, removing blank rows, removing duplicates, then deleting all other columns to create my new Lookup table. Then loaded that into the report. Everyhting works fine now. Cheers. 

  • neofjcn01's avatar
    neofjcn01
    Regular Visitor
    2 years ago
    It solved my problem, thanks