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