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

selimovd's avatar
selimovd
Most Valuable Professional
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
 

 

  • selimovd's avatar
    selimovd
    Most Valuable Professional
    5 years ago

    Hey community_pinki ,

     

    perfect, I'm happy you could solve that 🙂.

    Don't forget to mark all approaches that worked as solution ✔️ (you can mark multiple posts as solution). 

    Like this, you help the next person who is stumbling across this post to see immediately what worked.
     
    If you need any help please let me know.
     
    Best regards
    Denis