DAX Fridays! #171: Distinctcount with blanks

I show you in a previous video how to create a rowID using DAX, but how do you do it when you have blanks on the column?

Lets find out!

Link to the video mentioned:
Create a rowID with DAX:

Distinctcountnblanks not working:


SUBSCRIBE to learn more about Power and Excel BI!

Our PLAYLISTS:

☼☼☼☼☼☼☼☼☼☼

POWER BI COURSES:

Want to learn Power BI? How about you take one of our courses? Here you can find the available courses:

☼☼☼☼☼☼☼☼☼☼

ABOUT CURBAL:

▼▼▼▼▼▼▼▼▼▼

If you feel that any of the videos, downloads, blog posts that I have created have been useful to you and you want to help me keep on going, here you can do a small donation to support my work and keep the channel running:


Many thanks in advance!

▲▲▲▲▲▲▲▲▲▲


************





************


QUESTIONS? COMMENTS? SUGGESTIONS? You’ll find me here:
Twitter ► @curbalen, @ruthpozuelo

#CURBAL #SUBSCRIBE

[Harveyllt]

Nice video, i have a question about power bi. Can i create a column in multiple tables at the same time? idk if i can do it with M, btw im new in power bi

[mohtasimbillah]

Hey i have a request..
as we know that drillthrough dosent works for filters applied in measures..So is there any workaround.
lets say i have a measure calculate(count(product), filter(table, status=open).when i click on drillthrough it show all irrespective of status applied.As i have 5-6 measures in my chart so how we can tackle this..

[dannyhometown]

Good luck for office moving and have a great weekend. Stay safe.

[martinbubenheimer]

It's answer 3. Good to know this option exists!

[qianzhang]

Can Summarization means "Aggregation" of a category in Q18? Because when I put the region in a table, it automatically shows three regions instead of four!
Can somebody explain?

[idataview]

Hello,
I have a matrix whose sum of the elements in the columns and the rows do not match.
When I select the different months of a year, the result is good.
But when I want the result for the whole year, the result is wrong.
Can you help me.
cordially

[marce]

I'm rolling with Option 4. By definition, Azure means it crossed the Internet. A Gateway give access to the on-prem data in which case it would pull (across the internet) what it's authorized to. The SQL Server Column encryption would require a key of some sort to pass the data. No key, no data. So, if the requesting endpoint has the key then the information will be revealed and one can gather that the 'key' will only be issued to internal endpoints.

[akhilannan]

I would go for option 3. If data must not be transferred over internet then Azure Express Route must be used. It provides a private connection between onpremise network and Microsoft cloud.

[HachiAdachi]

Answer to Q19 = #3 ... Truly a wild guess... I think other options transfer data over the Internet, but I'm not positive...
Wishing you a successful office move and safe weekend!

[vida]

Ruth, you left DISTINCTCOUNTNONBLANK in your formula. However, after adding the new condition <> "", DISTICTCOUNT would work as well:
Calculated index (don't count blanks) =

CALCULATE(

DISTINCTCOUNT(Supplier[Supplier]),

Supplier[Supplier]<>"",

FILTER(Supplier,
Happy Friday and lovely weekend

[szymonkurowski]

Good luck with the office move! Take care :)

[tosinopeniyi]

Sorry for the stress. It's gonna be worthwhile.

[Sadasivpadhiary]

The answer is On-premises gateway (No. 1)

[elrevesyelderecho]

This is the kind of question where I don't know the technical part, I just know the answer. #3
Using some excluding logic, question said proprietary data Must Not be transferred over th Internet. So, won't be able to go online.
Gateway allows PBI Service cloud go to the data source and extracted. Option 2 it is already a way to access online. So, even is protected with the VPN, data is going online. #4 it is only one type of protections into the server. On my understanding, even encrypted data could go online if the admin or owner published allow it. So, #3 is my answer.