Forum Discussion

LotteLaugesen's avatar
LotteLaugesen
Icon for Helper V rankHelper 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...
ChiragGarg2512's avatar
ChiragGarg2512
Icon for Solution Sage rankSolution Sage
2 years ago

Try this DAX:

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

  • LotteLaugesen's avatar
    LotteLaugesen
    Icon for Helper V rankHelper V
    2 years ago

    Hi ChiragGarg2512 

     

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