Forum Discussion
Non blank value in column
Hi Team, I have base table as below Code Region Sales 123 10 123 ABC 20 456 30 456 DEF 40 I have created a Distinct value from code as below Code 123 ...
Try this:
Region Table =DISTINCT(SELECTCOLUMNS(FILTER('Table','Table'[Region]<>BLANK()),"Code", 'Table'[Code],"Region", 'Table'[Region]))
Ahmedx
Super User
Super UserBased on your description, I created data to reproduce your scenario. The pbix file is attached in the end
https://dropmefiles.com/eahTZ