Forum Discussion

community_pinki's avatar
community_pinki
Icon for Helper II rankHelper 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 following dax. 

 

 

Any Help would be Appreciated...


Thanks in Advance...

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

6 Replies

  • selimovd's avatar
    selimovd
    Icon for Most Valuable Professional rankMost 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
        Icon for Most Valuable Professional rankMost 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
         
  • Pragati11's avatar
    Pragati11
    Icon for Super User rankSuper 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