topic Need Help counting Occurrences for a given date (not cumulative) in DAX Commands and Tips

Need Help counting Occurrences for a given date (not cumulative)

Anonymous — Wed, 23 Dec 2020 19:42:32 GMT

Hello

I am looking count the number of times "CustomerX" appears in a single column on a given date. For Example, Bob appears twice on 11/13 and once on 11/14.

I have tried using COUNTX and SUMX but it counted all occurences instead of just for a single date. Once the occurence for the date is found I would like to create a new column or measure that shows if the occurence in one day is greater than 2 it populates column as "Frequent"

Date - Employee Name - Customer Name

11/13/2020	Employee 1	Bob
11/13/2020	Employee 2	Jen
11/13/2020	Employee 3	Bob
11/13/2020	Employee 4	Max
11/14/2020	Employee 3	Bob

Re: Need Help counting Occurrences for a given date (not cumulative)

AlB — Wed, 23 Dec 2020 20:00:21 GMT

Hi Anonymous

1. Place Date in the rows of a matrix visual and Customer name in the columns

2. Create this measure and place it in values of the visual:

Measure = IF ( COUNT ( TAble1[Customer Name] ) > 2, "Frequent" )

Please mark the question solved when done and consider giving a thumbs up if posts are helpful.

Contact me privately for support with any larger-scale BI needs, tutoring, etc.

Cheers

Re: Need Help counting Occurrences for a given date (not cumulative)

Fowmy — Wed, 23 Dec 2020 20:10:23 GMT

Anonymous

Add the following code as new column:

Occurrence = IF( COUNTROWS( FILTER( Table01, Table01[Customer Name] = EARLIER(Table01[Customer Name]) && Table01[Date] = EARLIER(Table01[Date]) ) ) > 2, "Frequent" )

If you need a measure, then add a table visual, keep Date and Customer name then add the following measure

Occurrence Measure = IF( COUNTROWS(Table01) > 2 , "Frequent")

________________________

If my answer was helpful, please click Accept it as the solution to help other members find it useful

Click on the Thumbs-Up icon if you like this reply 🙂

Website YouTube LinkedIn

Re: Need Help counting Occurrences for a given date (not cumulative)

Anonymous — Wed, 23 Dec 2020 21:12:11 GMT

Thank you very much! The IF function worked for me.