Forum Discussion

community_pinki's avatar
community_pinki
Helper II
5 years ago
Solved

Distinct values with NOBLANK

Hi All, I am trying to fetch all the distinct PrimaryName except blank value from existing table to a new one but there is blank value also present. Is that possible in Power BI.? I have tried fo...
Need Help
  • selimovd's avatar
    selimovd
    5 years ago

    Hey community_pinki ,

     

    you can remove that row with the FILTER function:

    Creators =
FILTER(
    DISTINCT(
        VALUES( CREATOR_DATA[PrimaryName] )
    ),
    CREATOR_DATA[PrimaryName] <> BLANK()
)

     

    If you need any help please let me know.
    If I answered your question I would be happy if you could mark my post as a solution ✔️ and give it a thumbs up 👍
     
    Best regards
    Denis
     

     

  • Pragati11's avatar
    Pragati11
    5 years ago

    Hi community_pinki ,

     

    myTable = DISTINCT(FILTER(VALUES(Attendee[Completed]),LEN(Attendee[Completed])>0))

     

    Replace your tablename and columnname in above DAX.

     

    Thanks,

    Pragati

Pragati11's avatar
Pragati11
Super User
5 years ago

Hi community_pinki ,

 

myTable = DISTINCT(FILTER(VALUES(Attendee[Completed]),LEN(Attendee[Completed])>0))

 

Replace your tablename and columnname in above DAX.

 

Thanks,

Pragati

  • Pragati11's avatar
    Pragati11
    Super User
    5 years ago

    HI community_pinki ,

     

    I am glad the solution works. Please mark it as a solution if you are happy with it. 🙂

     

    Thanks,

    Pragati