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...
Try this DAX:
DistinctCustomerGroup = Distinct(Filter('Dim_Customers', Not IsBlank('Dim_Customers'[Customer group name])))
Thank you, but it's inside Query Designer in Report Builder and it doesn't accept that