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

[shaunguyver]

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!

[AlB · Accepted solution]

Hi @shaunguyver

How about placing this measure in a Card visual:

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