DISTINCTCOUNT with an IF, possible?

[Gauteweb]

Hi. I've worked with Power BI for about 6 months, but not fiddled to much with DAX. Now I'm faced with an issue.

I have a table with two fields, Name and Value. I want to do a DISTINCTCOUNT of names, but only those where they have a value >0.

Any tips?

[Gauteweb · Accepted solution]

OK, so I think I figured it out:

DistinctNames =

CALCULATE(

DISTINCTCOUNT(CosmosDB[Name]); CosmosDB[Value]>0)