Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Gauteweb
Advocate II
Advocate II

DISTINCTCOUNT with an IF, possible?

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?

1 ACCEPTED SOLUTION
Gauteweb
Advocate II
Advocate II

OK, so I think I figured it out:

DistinctNames =
CALCULATE(
DISTINCTCOUNT(CosmosDB[Name]); CosmosDB[Value]>0)

View solution in original post

1 REPLY 1
Gauteweb
Advocate II
Advocate II

OK, so I think I figured it out:

DistinctNames =
CALCULATE(
DISTINCTCOUNT(CosmosDB[Name]); CosmosDB[Value]>0)

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors