Showing results for 
Search instead for 
Did you mean: 
Frequent Visitor

Count Rows distinct values

Hi All,


I have a table containing employee names and booked annual leave dates and whether each date is in the past or future (see small example screenshot at bottom).


I have data telling me how much remaining leave each employee has and I have this table telling me what past/ future bookings. What I need to do is create a report summarising how annual leave by remaining, taken past, taken pending (future) - ideally in a bar chart.

So, to get this data, I need a column/ measure showing many future and how many past bookings each person has, but i can't figure out how to do this and what combination of formulas I can use. I have created a related table with distinct values (I think..!) - not sure if that's necessary...


Obviously in this table each person has multiple entries, I have played about with IFs and Distinct Counts, Related, Count Rows etc but can't seem to get it right!


Thanks in advance!



Future Past.PNG

Super User IV
Super User IV

Re: Count Rows distinct values

Perhaps something like:


PastMeasure = COUNTROWS(FILTER('Table',[Past or Future] = "Past Booking"))

FutureMeasure = COUNTROWS(FILTER('Table',[Past or Future] = "Future Booking"))


Not the Power BI thought police...

I have NEW book! 
DAX Cookbook from Packt
Over 120 DAX Recipes!
Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!

Helpful resources

New Ranks Launched March 24th!

New Ranks Launched March 24th!

The time has come: We are finally able to share more details on the brand-new ranks coming to the Power BI Community!

‘Better Together’ Contest Finalists Announced!

‘Better Together’ Contest Finalists Announced!

Congrats to the finalists of our ‘Better Together’-themed T-shirt design contest! Click for the top entries.

Arun 'Triple A' Event Video, Q&A, and Slides

Arun 'Triple A' Event Video, Q&A, and Slides

Missed the Arun 'Triple A' event or want to revisit it? We've got you covered! Check out the video, Q&A, and slides now.

Top Solution Authors
Top Kudoed Authors