Forum Discussion
1001
Resolver II
3 years agoRemoving 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...
grazitti_sapna
Super User
3 years agoHey Try using this Dax formula
SubProduct Grp = Distinct(Not(isblank(Masterdata[Sub Category])))