measurement
1 Topic
Measrurement for count of rowrs based on text value
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, HarriSolved588Views0likes2Comments