I am trying to calculate a measure for the no.rows in a table visual. I have 4 columns (Employee Name, Product, Total Hours and Marketing Campaign) and Id like to calculate the no.rows as there could be multiple rows for one employee who spends more time selling products per campaign cycle.
I have created a measure which counts Employee and created the following calculation:
Total = CALCULATE([Total Employees], Product, Marketing Campaign)
I understand that the Product and Marketing Campaign column are not the type = True/False but not sure how to proceed.
Please advise
SonzPortal is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.