Forum Discussion
How to get distinct values without null values for a parameter in Report Builder
Hi What I'm tryng to achieve is to get distinct values from 'Dim_Customers'[Customer group name] but I want to remove null values. Can anybody tell me the correct syntax or how to do it? This...
Sorry for the misunderstanding. Try this:
EVALUATE VALUES('Dim_Customers'[Customer group name]),FILTER('Dim_Customers', (NOT ISBLANK('Dim_Customer'[Customer group name])) && 'Dim_Customer'[Customer group name] <> "")
