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