How to get distinct values without null values for a parameter in Report Builder

[LotteLaugesen]

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 doesn't work 😞
EVALUATE VALUES('Dim_Customers'[Customer group name]),FILTER('Dim_Customers','Dim_Customers'[Customer group name] <> BLANK())

BR
Lotte

[ChiragGarg2512]

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] <> "")

[LotteLaugesen]

Hi @ChiragGarg2512 

Thank you, but I get this syntax error:

[ChiragGarg2512]

Try this DAX:

DistinctCustomerGroup = Distinct(Filter('Dim_Customers', Not IsBlank('Dim_Customers'[Customer group name])))

[LotteLaugesen]

Hi @ChiragGarg2512 

Thank you, but it's inside Query Designer in Report Builder and it doesn't accept that