Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Count Data based on Filter

Hello - I'm sure this is simple but I'm stumped.  Below is some sample data:   Agent ID Cust ID Sale 1 1 3/1/2020 1 2 3/2/2020 1 3 3/3/2020 1 4 3/3/2020 1 5 3/4/2020 ...
Need Help
v-kelly-msft's avatar
v-kelly-msft
Community Support
6 years ago

Hi Anonymous ，

 

You need a measure as below：

 

 

Measure = 
IF(SELECTEDVALUE('Table'[Second Sale]) in VALUES('Table 2'[Date]),SELECTEDVALUE('Table'[Second Sale]),BLANK())

 

 

Finally you will see:

 

 

For the related .pbix file,pls click here.

 

Best Regards,
Kelly
Did I answer your question? Mark my post as a solution!

 

 

 

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Hi Kelly - thanks!

 

One more question - how can I get this into a Card visual with a count of the returned values.  In your example, I'd like to use a card visual displaying 3.  Make sense?

 

thanks!