Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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...
Solved! Go to Solution.
Hey @community_pinki ,
you can remove that row with the FILTER function:
Creators =
FILTER(
DISTINCT(
VALUES( CREATOR_DATA[PrimaryName] )
),
CREATOR_DATA[PrimaryName] <> BLANK()
)
Hi @community_pinki ,
myTable = DISTINCT(FILTER(VALUES(Attendee[Completed]),LEN(Attendee[Completed])>0))
Replace your tablename and columnname in above DAX.
Thanks,
Pragati
Hi @community_pinki ,
myTable = DISTINCT(FILTER(VALUES(Attendee[Completed]),LEN(Attendee[Completed])>0))
Replace your tablename and columnname in above DAX.
Thanks,
Pragati
HI @community_pinki ,
I am glad the solution works. Please mark it as a solution if you are happy with it. 🙂
Thanks,
Pragati
Hey @community_pinki ,
you can remove that row with the FILTER function:
Creators =
FILTER(
DISTINCT(
VALUES( CREATOR_DATA[PrimaryName] )
),
CREATOR_DATA[PrimaryName] <> BLANK()
)
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).
User | Count |
---|---|
88 | |
74 | |
69 | |
65 | |
58 |
User | Count |
---|---|
104 | |
94 | |
76 | |
62 | |
59 |