Forum Discussion

LotteLaugesen's avatar
LotteLaugesen
Helper V
2 years ago

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

BR
Lotte

4 Replies

  • ChiragGarg2512's avatar
    ChiragGarg2512
    Solution Sage
    2 years ago

    Try this DAX:

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

  • ChiragGarg2512's avatar
    ChiragGarg2512
    Solution Sage
    2 years ago
    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] <> "")