topic Re: Measrurement for count of rowrs based on text value in DAX Commands and Tips

Measrurement for count of rowrs based on text value

Harri — Sun, 22 Oct 2023 07:04:53 GMT

Hi,

This might be a simple question but I am q bit stuck with it.

Data is formatted like this (Table1):

Company; Sales-date
Acme Inc; 01.01.2022
Acme Inc; 02.01.2022
Acme Inc; 03.01.2022
Acme Inc; 04.01.2022
Customer Corp; 05.01.2022
Customer Corp; 06.01.2022
Customer Corp; 07.01.2022
SMB Ltd; 08.01.2022
SMB Ltd; 09.01.2022

Company column is a text field and I would like to summarize how many occurences there is for each value. For example, how many sales interactions was there in January for each company.

I would expect results like this for given data in report table: Company; number of sales activities:
Acme Inc; 4
Customer Corp; 3
SMB Ltd; 08.01.2022

I am adding a measurement like this:
Measure = COUNTROWS(filter(Table1, Table1[Company] = EARLIER(Company)))

This provides error:
EARLIER/EARLIEST refers to an earlier row context which doesn't exist.

I am doing something wront, but what?

Kind Regards,

Harri

Re: Measrurement for count of rowrs based on text value

ValtteriN — Sun, 22 Oct 2023 07:24:43 GMT

Hi,

COUNT should work for your example. E.g.

Measure 2 = COUNT('Table (8)'[Sales-date])

In your measure you used EARLIER. EARLIER should be used in the context of calculated columns.

I hope this post helps to solve your issue and if it does consider accepting it as a solution and giving the post a thumbs up!

My LinkedIn: https://www.linkedin.com/in/n%C3%A4ttiahov-00001/

Re: Measrurement for count of rowrs based on text value

Harri — Sun, 22 Oct 2023 14:59:33 GMT

Thank you ValtteriN, this did the job! Much appriciated!