Distinct values with NOBLANK

[community_pinki]

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...

[selimovd · Accepted solution]

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

Blog: WhatTheFact.bi

Follow me: twitter.com/DenSelimovic

[Pragati11 · Accepted solution]

Hi @community_pinki ,

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

Replace your tablename and columnname in above DAX.

Thanks,

Pragati

[community_pinki]

Hi @Pragati11 ,

Thanks it works.

[Pragati11]

HI @community_pinki ,

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

Thanks,

Pragati

[selimovd · Accepted solution]

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

Blog: WhatTheFact.bi

Follow me: twitter.com/DenSelimovic

[community_pinki]

Hi @selimovd ,

Thanks..this Dax also worked.

[selimovd]

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

Blog: WhatTheFact.bi

Follow me: twitter.com/DenSelimovic