TOPN and LASTNONBLANK

[antalgu]

Hello friends, today I would like to ask a rather strange question. The thing is that I can use either two TOPN or a TOPN and LASTNONBLANK to get a text (for example the name of a campaign) by the amounts of rows that appear containing it (I basically have a table of phone calls where each one has a campaign assigned to it, and have a measure that just countrows where the call is valid (I determine this by watching at another column) that serves me to rank them). So up to here everything is perfect, the only problem I have is that there are calls that have no campaign and if the campaign with no value is the 3rd one with the most calls (for example) if I go searching for the 3rd campaign with more calls with the method I described I find the 4rd one, because both TOPN and LASTNONBLANK don't count blank values. I've been searching to see if there was any function similar to any of those two but that is able to return blank values but without much luck.

Is there any way to get what I want?

[lbendlin]

You can't have it both ways.

---

phone calls where each one has a campaign assigned to it

---

---

problem I have is that there are calls that have no campaign

---

[antalgu]

Yea, I figured, but why is it that there are no functions of this type that return blank values? Because the blank campaign is an actual campaign in my case, and in other people cases the blank campaign could for example refer to the phone calls in which the system used for typing out how the calls have gone has had a problem or something? Wouldn't it be useful to have functions than could return blank as a value?

[lbendlin]

DAX functions do return BLANK() if there are no results.  You may want to review your problem description and simplify the ask a bit. Solve the issue one step after the other.