Showing results for 
Search instead for 
Did you mean: 
a4apple Regular Visitor
Regular Visitor

Need help with DAX Query DISTINCT Count

Hi all,

I have a table where I am using a measure to find the count of distinct Rkey's in a table that has the level > 5.


The DAX statement I am using is giving me wrong data. 

Measure 1 := CALCULATE(COUNTROWS(DISTINCT('Event'[RKey])), FILTER('Event', 'Event'[level] > 5))


When I use this for a query I am getting wrong data. I am seeing data for Keys that doesn't have any event on that particular day. 

Please help me in understanding what I am doing wrong.


Thanks in advance.


Moderator v-sihou-msft

Re: Need help with DAX Query DISTINCT Count



In this scenario, since you alread filter out the "'Event'[level] > 5" table context, it supposes to return BLANK() for Keys with no Event. I can't reproduced your issue.



Please share some sample data if possible.



Helpful resources

Can You Solve These Challenge

Challenge: Can You Solve These?

Find out how to participate in the first Power BI 'Can You Solve These?' challenge.

Community News & Announcements

Community News & Announcements

Get your latest community news and announcements.

Virtual Launch Event

Microsoft Business Applications October Virtual Launch Event

Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

Community Kudopalooza

Win Power BI Swag with Community Kudopalooza!

Each week, complete activities and be qualified in the drawing for cool Power BI Swag.

Users Online
Currently online: 216 members 2,302 guests
Please welcome our newest community members: