Hello,
I need help with the following topic: I have 1 Table which includes the column "Company" and the column "Last Login". Based on the column "Last Login" I created a calculated column "Active/Inactive" that contains a 1 if the user logged in in the last 3 months or it contains a 0 if the user didn`t log in in the last 3 months.
Now I have the case that I got a row for each user of our webshop, but it is possible that there are more than 1 user working for the same company. That means that the calculated column "Active/Inactive" just gives me the information if the user is active or not but it doesn`t give me the information if a whole company is active (=> has at least 1 active user).
To get that information I want to build the sum of the "Active/Inactive" table for all users of a company. If a company has a higher value than 0 it is active (=> has at least one active user) if the value for the company is 0 then it is inactive (=> has no active users).
I have zero clue how to build a measure that gives me the sum of the values in a column (active/inactive user) if the rows have the same value in a different column (company).
I hope that somebody is able to understand my problem.
