cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
shaunguyver Member
Member

Count distinct value in column, and filter by date in separate column

I have a table called 'Sales Pipeline' with the following columns: - Resource (format: text) - End (format: date) I want to create a measure that counts the number of distinct values in 'Resource', and then filters to only future dates (ie, after today) in 'End' column. Any ideas? Thanks!
1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Super User
Super User

Re: Count distinct value in column, and filter by date in separate column

Hi @shaunguyver

 

How about placing this measure in a Card visual:

 

 

Measure =
CALCULATE ( DISTINCTCOUNT ( Table1[Resource] ), Table1[End] > TODAY () )

 

1 REPLY 1
Highlighted
Super User
Super User

Re: Count distinct value in column, and filter by date in separate column

Hi @shaunguyver

 

How about placing this measure in a Card visual:

 

 

Measure =
CALCULATE ( DISTINCTCOUNT ( Table1[Resource] ), Table1[End] > TODAY () )